dump Functions

Started by Dany De Bontridderalmost 20 years ago2 messagesgeneral
Jump to latest
#1Dany De Bontridder
dany@alchimerys.be

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.

#2Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Dany De Bontridder (#1)
Re: dump Functions

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