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@xxxxxxxxx> 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?
