Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Scripting f...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 7 Topic 15503 of 16987
Post > Topic >>

Re: Scripting function definitions as SQL?

by postgres.developer@[EMAIL PROTECTED] ("Postgres User") May 11, 2008 at 11:28 AM

Unfortunately I didn't see a way to tell pg_dump to dump only objects
of a specific type, like functions or sequences.  It requires
additional coding to parse the output and that's less than ideal...

>  Does pg_dump not do what you want?

On Sun, May 11, 2008 at 6:49 AM, Martijn van Oosterhout
<kleptog@[EMAIL PROTECTED]
> wrote:
> On Sun, May 11, 2008 at 06:12:40AM -0700, Postgres User wrote:
> > Has anyone written a function that scripts out all the functions in a
> > database as full SQL statements (Create Function.....)
> >
> > I found the below SQL will return all the fields needed to build a SQL
> > statement, but it would take some work to combine the field values
> > correctly to get the right format.  So does anyone know if the code
> > has already been written by someone else?

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 7 Posts in Topic:
Scripting function definitions as SQL?
postgres.developer@[EMAIL  2008-05-11 06:12:40 
Re: Scripting function definitions as SQL?
kleptog@[EMAIL PROTECTED]  2008-05-11 15:49:37 
Re: Scripting function definitions as SQL?
postgres.developer@[EMAIL  2008-05-11 11:28:37 
Re: Scripting function definitions as SQL?
depesz@[EMAIL PROTECTED]   2008-05-11 20:43:25 
Re: Scripting function definitions as SQL?
postgres.developer@[EMAIL  2008-05-11 12:08:36 
Re: Scripting function definitions as SQL?
reece@[EMAIL PROTECTED]   2008-05-11 22:27:51 
Re: Scripting function definitions as SQL?
singh.gurjeet@[EMAIL PROT  2008-05-12 12:38:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 14 10:27:43 CDT 2008.