Re: Dumping functions with pg_dump - Mailing list pgsql-general

From Greg Corradini
Subject Re: Dumping functions with pg_dump
Date
Msg-id BANLkTimgrhwg=E_+wXSwoFYeq843nocu6g@mail.gmail.com
Whole thread Raw
In response to Re: Dumping functions with pg_dump  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Thanks for the reply Raymond!

This is all through remote terminal so I can't use pg_admin ;(

Maybe some more quick context.... I don't want to dump whole database b/c the thing is 12GB and for the application we're building we only access certain tables in the DB. There's one table that has two triggers associated to it, each which in turn references it's own procedure.

So my pg_dump syntax has a lot of -t <table_name> -t<table_nameII> in it to target only the tables I want. But the procedures tied to the triggers aren't coming with it unless I do the whole dump.

thx

On Tue, Apr 5, 2011 at 4:19 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 06/04/2011 00:15, Greg Corradini wrote:
Hello,
Is it possible yet in 8.4 to pg_dump specific functions without having
to do the whole pg_restore thing?

If I understand correctly what you're trying to do, a handy alternative is to use pgAdmin, right click on the function in the tree view, and select Scripts -> Create.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



--
Greg

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Dumping functions with pg_dump
Next
From: Jerry Sievers
Date:
Subject: Re: Dumping functions with pg_dump