Re: [HACKERS] One more option for pg_dump...

2008-02-26 Thread Brendan Jurd
On Wed, Feb 27, 2008 at 2:29 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > You could just pull up a psql session and do a "select > > pg_func_def(regproc);" and there you go, one fully formed CREATE > > FUNCTION statement. > > \df+ function(type) > Sure, if your idea of a good time is lo

Re: [HACKERS] One more option for pg_dump...

2008-02-26 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 27 Feb 2008 13:05:44 +1100 "Brendan Jurd" <[EMAIL PROTECTED]> wrote: > > You could just pull up a psql session and do a "select > pg_func_def(regproc);" and there you go, one fully formed CREATE > FUNCTION statement. \df+ function(type) Jo

Re: [HACKERS] One more option for pg_dump...

2008-02-26 Thread Brendan Jurd
On Tue, Feb 26, 2008 at 12:48 AM, David BOURIAUD <[EMAIL PROTECTED]> wrote: > I haven't found any option to dump any user-defined function stored in a > database, unless doing a pg_dump -D -s database, but so far one would get the > definitions of the tables, the permissions, the triggers, and s

Re: [HACKERS] One more option for pg_dump...

2008-02-25 Thread Leonardo Cezar
On Mon, Feb 25, 2008 at 12:33 PM, David BOURIAUD <[EMAIL PROTECTED]> wrote: > Le lundi 25 février 2008, Leonardo Cezar a écrit : > > Hi Leonardo, > Thanks for your quick answer, I didn't know it was a TODO item, and that > somepeople were working on it... Keep going, then, cause I'm really waiti

Re: [HACKERS] One more option for pg_dump...

2008-02-25 Thread David BOURIAUD
Le lundi 25 février 2008, Leonardo Cezar a écrit : Hi Leonardo, Thanks for your quick answer, I didn't know it was a TODO item, and that somepeople were working on it... Keep going, then, cause I'm really waiting for these features ! > On Mon, Feb 25, 2008 at 10:48 AM, David BOURIAUD > > <[EMAI

Re: [HACKERS] One more option for pg_dump...

2008-02-25 Thread Leonardo Cezar
On Mon, Feb 25, 2008 at 10:48 AM, David BOURIAUD <[EMAIL PROTECTED]> wrote: > Could there be an option to pg_dump (let's say --function [func_name]) to be > abble to dump the complete source code of a function in a separate file, or > on the terminal ? It's a TODO item. Just not to functions an

[HACKERS] One more option for pg_dump...

2008-02-25 Thread David BOURIAUD
Hi all, On the 6th of february, there's been a thread about adding new options to pg_dump, but it is now too late for me to add comments to this thread, since all that was said wouldn't be readable at this time, so I add an new thread here. I haven't found any option to dump any user-defined fun