On Thu, Feb 14, 2013 at 3:37 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
