Postgres Pro
Downloads
Home   >   mailing lists

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

From Bradley Holbrook, Servillian Technology
Subject Dump SQL DDL of all functions in DB
Date
Msg-id 044501cc5236$1b376ab0$51a64010$@servillian.com
Whole thread Raw
Responses Re: Dump SQL DDL of all functions in DB  (Joe Conway <mail@joeconway.com>)
Re: Dump SQL DDL of all functions in DB  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-admin
Tree view

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

bholbrook@servillian.com

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:

 

Twitter | Facebook | Support Website

 

pgsql-admin by date:

Previous
From: Tom Lanyon
Date:
Subject: PD_ALL_VISIBLE flag set - autovacuum ignoring dead tuples
Next
From: Shivakumar Ramannavar
Date:
Subject: my table is empty, pg_relation_size(name) return 38 MB