Thread: dump Functions

dump Functions

From
Dany De Bontridder
Date:
Hello, I would like to dump all my functions and only the functions from a
database, how can I do that ??

So far, I can only get it with

pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'

Regards,

D.

Re: dump Functions

From
"Jim C. Nasby"
Date:
On Sat, Apr 29, 2006 at 12:00:15AM +0200, Dany De Bontridder wrote:
> Hello, I would like to dump all my functions and only the functions from a
> database, how can I do that ??
>
> So far, I can only get it with
>
> pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'

There's been talk of allowing a finer-grain selection of what pg_dump
will dump, but I don't think there's anything in there right now to
support that.

What's wrong with using awk like you are?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461