Need regexp_replace help
Trying ( and failing) to get this to run...
select regexp_replace(pg_get_functiondef(proname::regproc),E'[ ]+\\+\n','\n') from pg_proc where proname = '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 sent 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 !
On Thu, Feb 14, 2013 at 3:37 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
Trying ( and failing) to get this to run...
select regexp_replace(pg_get_functiondef(proname::regproc),E'[
]+\\+\n','\n') from pg_proc where proname = '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 sent
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 :-)
this isn't a regex issue, but a psql one. Just disable alignment
and set tuples only etc. Whenever I do this type of thing (intend
psql output to some consumer), it's:
psql -XtAqc "query" > file
there are similar options to do this via various \set commands.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general