pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bradley Holbrook, Servillian Technology <bholbrook@servillian.com>
To: pgsql-admin@postgresql.org
Subject: Dump SQL DDL of all functions in DB
Date: Wed, 3 Aug 2011 16:35:59 -0700
Message-ID: <044501cc5236$1b376ab0$51a64010$@servillian.com> (raw)

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@servillian.com> bholbrook@servillian.com

 <mailto:bholbrook@telus.blackberry.net> bholbrook@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:

 

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

 

view thread (3+ messages)  latest in thread

Message-ID: <044501cc5236$1b376ab0$51a64010$@servillian.com>
Permalink:  ../044501cc5236$1b376ab0$51a64010$@servillian.com/
Also on:    postgresql.org/message-id/044501cc5236$1b376ab0$51a64010$@servillian.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bholbrook@servillian.com
  Subject: Re: Dump SQL DDL of all functions in DB
  In-Reply-To: <044501cc5236$1b376ab0$51a64010$@servillian.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox