Re: Dump SQL DDL of all functions in DB - Mailing list pgsql-admin

From Joe Conway
Subject Re: Dump SQL DDL of all functions in DB
Date
Msg-id 4E415167.3010901@joeconway.com
Whole thread Raw
In response to Dump SQL DDL of all functions in DB  ("Bradley Holbrook, Servillian Technology" <bholbrook@servillian.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Raghavendra
Date:
Subject: Re: Streaming replication between x86 and x86_64 hosts
Next
From: jtkells@verizon.net
Date:
Subject: Re: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)