"Bradley Holbrook, Servillian Technology" <bholbr...@servillian.com> writes:
> 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 select pg_get_functiondef(p.oid) || ';' from pg_proc p join pg_namespace n on p.pronamespace = n.oid where n.nspname = 'public' ; psql -Atq -f... HTH > Bradley A Holbrook > > Sr. Web Developer > > Servillian Technology Ltd > > http://www.servillian.com > > bholbr...@servillian.com > > bholbr...@telus.blackberry.net > > Cell: (250) 309 ó 7408 > > Office: (250) 260 ó 4351 ext. 13 > > ************************************* > > For up to the minute news, support notifications and other pertinant > information regarding your website or related > services, you can use the following resources: > > Twitter | Facebook | Support Website > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
