Re: [GENERAL] Dumping functions with pg_dump

2011-04-06 Thread Vibhor Kumar
On Apr 6, 2011, at 4:45 AM, 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 it is possible, what is the syntax to dump a specific function? > > If not possible, then how does one use pg_restore t

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Adrian Klaver
On Tuesday, April 05, 2011 5:24:13 pm Greg Corradini wrote: > On Tue, Apr 5, 2011 at 4:30 PM, Adrian Klaver wrote: > > Thx for the replies Adrian and Jerry, > > Those are both options. Jerry, your suggestion is the work around I've > already used. Adrian, I did not know you could do that. Still.

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Greg Corradini
On Tue, Apr 5, 2011 at 4:30 PM, Adrian Klaver wrote: > On Tuesday, April 05, 2011 4:19:56 pm Raymond O'Donnell 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? > >

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Adrian Klaver
On Tuesday, April 05, 2011 4:19:56 pm Raymond O'Donnell 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 al

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Jerry Sievers
Greg Corradini writes: > Hello, > Is it possible yet in 8.4 to pg_dump specific functions without having to do > the whole pg_restore thing? > > If it is possible, what is the syntax to dump a specific function? > > If not possible, then how does one use pg_restore to target a specific > function

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Greg Corradini
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 t

Re: [GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Raymond O'Donnell
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, an

[GENERAL] Dumping functions with pg_dump

2011-04-05 Thread Greg Corradini
Hello, Is it possible yet in 8.4 to pg_dump specific functions without having to do the whole pg_restore thing? If it is possible, what is the syntax to dump a specific function? If not possible, then how does one use pg_restore to target a specific function? thx

Re: [GENERAL] Dumping functions

2006-02-28 Thread Bricklen Anderson
Steve Crawford wrote: How can I dump a function definition with pg_dump? Background: We often need to create objects that are all relevant to only a specific project. Sometimes it is a single table. Other times there are many tables, indexes, views, rules, triggers and functions. All the obje

[GENERAL] Dumping functions

2006-02-27 Thread Steve Crawford
How can I dump a function definition with pg_dump? Background: We often need to create objects that are all relevant to only a specific project. Sometimes it is a single table. Other times there are many tables, indexes, views, rules, triggers and functions. All the objects share a unique subs