"Bradley Holbrook, Servillian Technology" <bholbrook@xxxxxxxxxxxxxx> 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 > > bholbrook@xxxxxxxxxxxxxx > > bholbrook@xxxxxxxxxxxxxxxxxxxx > > 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.consulting@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
