How to change the path in the database field?

S

Salavat Sharapov2014-06-30 06:58:31

PostgreSQL

Salavat Sharapov, 2014-06-30 06:58:31

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

In order to leave comments, you need to log in

1 answer(s)

P

Push Pull, 2014-06-30
@desperadik

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