Message-ID: <4E415167.3010901@joeconway.com>
Date: Tue, 09 Aug 2011 08:25:27 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.8.0.12) Gecko/20071019 Fedora/1.5.0.12-3.fc6 pango-text
	Thunderbird/1.5.0.12 Mnenhy/0.7.5.666
MIME-Version: 1.0
To: "Bradley Holbrook, Servillian Technology" <bholbrook@servillian.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Dump SQL DDL of all functions in DB
References: <044501cc5236$1b376ab0$51a64010$@servillian.com>
In-Reply-To: <044501cc5236$1b376ab0$51a64010$@servillian.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit

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