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@xxxxxx> wrote:
On 06/04/2011 00:15, Greg Corradini wrote: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.
Hello,
Is it possible yet in 8.4 to pg_dump specific functions without having
to do the whole pg_restore thing?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Greg
