Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
Salavat Sharapov2014-06-30 06:58:31
PostgreSQL
Salavat Sharapov, 2014-06-30 06:58:31

How to change the path in the database field?

Nothing in sql at all..*( You need to change the path to the file, the path is written in the
doc_dir column as document/123.doc and there are about 500 such records . /2dir/document/123.doc

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
P
Push Pull, 2014-06-30
@desperadik 

UPDATE table set doc_dir = concat( '1dir/2dir/', doc_dir ) WHERE (условие выборки)

Similar questions
A
Andrey2016-05-03 19:22:06
How to make a Django + PostgreSQL recursive query? 1Reply
N
Nikolai Khoziashev2021-12-07 23:41:04
How to correctly write the to_char function in postgresql? 1Reply
D
Danil Chekalin2016-05-05 14:34:59
Why does Postgres (PostGis) not correctly calculate occurrences of points in a radius? 1Reply
T
tupoi_nub2016-05-08 08:19:23
I need to write a postgresql query, can you help me? 1Reply
D
DUDE2020-08-27 00:12:55
[WinError 10053] An established connection was aborted by the software in your host machine? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question