On 08/03/2011 04:35 PM, Bradley Holbrook, Servillian Technology wrote: > Anyone know how to dump the DDL of every function in a schema into one file? > > Essentially, I’d like to do something like: > > ‘functions ddl dump cmd’ public functions.sql The easiest way is probably to do a schema-only dump and then edit the result to eliminate everything you don't want. E.g.: pg_dump --schema-only --schema=foobar test Note that "--schema-only" means object definitions without data whereas "--schema=foobar" is saying to only consider objects in the schema called foobar. The work "schema" here has two different meanings. HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
