Re: Dumping functions with pg_dump

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(at)iol(dot)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(at)iol(dot)ie
>

--
Greg