Re: How to dump JUST procedures/funnctions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to dump JUST procedures/funnctions?
Date: 2010-03-22 12:03:39
Message-ID: 15756.1269259419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca> writes:
>> Afaik no, you can make a schema-dump and extract the function
>> declarations from the dump.

> Yeah, that's what I was doing. Bloody tedious. Thanks anyway!

It seems like it could be automated.

pg_dump -Fc -s mydb >mydb.dump
pg_restore -l mydb.dump | grep FUNCTION >mydb.list
pg_restore -L mydb.list mydb.dump >functionsonly.txt

(or something more or less like that --- too early in the morning...)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-22 12:18:08 Re: Determining the OID of a certain type
Previous Message Carsten Kropf 2010-03-22 11:34:29 Determining the OID of a certain type