Dump SQL DDL of all functions in DB

From: "Bradley Holbrook, Servillian Technology" <bholbrook(at)servillian(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Dump SQL DDL of all functions in DB
Date: 2011-08-03 23:35:59
Message-ID: 044501cc5236$1b376ab0$51a64010$@servillian.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Bradley A Holbrook

Sr. Web Developer

Servillian Technology Ltd

<http://www.servillian.com/> http://www.servillian.com

<mailto:bholbrook(at)servillian(dot)com> bholbrook(at)servillian(dot)com

<mailto:bholbrook(at)telus(dot)blackberry(dot)net> bholbrook(at)telus(dot)blackberry(dot)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:

<http://twitter.com/#!/Servillian> Twitter |
<http://www.facebook.com/pages/Servillian-Technology-Ltd/144527612254727>
Facebook | <http://support.servillian.ca/> Support Website

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shivakumar Ramannavar 2011-08-04 11:22:36 my table is empty, pg_relation_size(name) return 38 MB
Previous Message Sumeet Jauhar 2011-08-03 17:14:47 Fwd: Suspected Postgres Datacorruption