Need regexp_replace help

Поиск
Список
Период
Сортировка
Искать
От
Gauthier, Dave
Тема
Need regexp_replace help
Дата
Msg-id
0AD01C53605506449BA127FB8B99E5E161146A32@FMSMSX105.amr.corp.intel.com
Список
Дерево обсуждения
Need regexp_replace help "Gauthier, Dave" <dave.gauthier@intel.com>
Re: Need regexp_replace help Merlin Moncure <mmoncure@gmail.com>
Trying ( and failing) to get this to run...

select regexp_replace(pg_get_functiondef(proname::regproc),E'[ ]+\\+\n','\n=
') from pg_proc where proname =3D 'maketime';

Goal is to remove the space padding and the "+" at the end of each line in =
the dump of pg_get_functiondef, something that could actually be run if sen=
t out to a file (\o) and then read into another DB (\i).  Of course the ";"=
 would have to be appended at the end, but I can manage that :-)

Thanks in Advance !
В списке pgsql-general по дате отправления
От: Aleksey Tsalolikhin
Дата:
От: Merlin Moncure
Дата:
Сообщение: Re: Need regexp_replace help
FAQ