Dumping functions

Steve Crawford wrote:

How can I dump a function definition with pg_dump?

Background: We often need to create objects that are all relevant to
only a specific project. Sometimes it is a single table. Other times
there are many tables, indexes, views, rules, triggers and functions.
All the objects share a unique substring that identifies the project so
automatically creating the list is easy.

When I use pg_dump to dump a table I will by default also get the
associated indexes, rules and triggers. Views can be dumped just like
tables. So all I need to do to archive the whole mess is to automate the
dump of the functions.

Ideas?

Cheers,
Steve

This thread has a few options available
http://archives.postgresql.org/pgsql-general/2005-10/msg01589.php

As a special promotion we are offering PG Lightning Admin for the blow
out price of 5 dollars per copy.

Our goal is to reach 1000 sales by the first day of spring, and 1
dollar per sale will go to the Postgresql project, but only if we reach
the 1000 unit mark.

To get this great product for 5 bucks, use the coupon code
winterblowout when ordering.

If we make it to the 1000 unit mark by the first day of spring the
Postgresql project will get a cool 1000 dollar donation.

For more information on PGLA and to order see:

http://www.amsoftwaredesign.com

Feel free to spread the word on this.

Thanks,

Tony Caduto
AM Software Design

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tony Caduto
Sent: 01 March 2006 19:44
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Special offer with a possible dontation to
the project

Our goal is to reach 1000 sales by the first day of spring,

You might want to name a date for that - the first day of spring is just
ending here :-)

Regards, Dave.

On Wed, 2006-03-01 at 13:44 -0600, Tony Caduto wrote:

As a special promotion we are offering PG Lightning Admin for the blow
out price of 5 dollars per copy.

Our goal is to reach 1000 sales by the first day of spring, and 1
dollar per sale will go to the Postgresql project, but only if we reach
the 1000 unit mark.

To get this great product for 5 bucks, use the coupon code
winterblowout when ordering.

If we make it to the 1000 unit mark by the first day of spring the
Postgresql project will get a cool 1000 dollar donation.

For more information on PGLA and to order see:

http://www.amsoftwaredesign.com

Feel free to spread the word on this.

I know I've said it before, but I would without a shadow of a doubt buy
this if it ran natively under Linux. :(

I've tried it under Wine and it was just too slow and unstable to be
useful.

Pity...

--

Russ

Sorry,
First day of spring for this promotion = March 21st

On Wed, 2006-03-01 at 13:54, Russ Brown wrote:

I know I've said it before, but I would without a shadow of a doubt buy
this if it ran natively under Linux. :(

I've tried it under Wine and it was just too slow and unstable to be
useful.

Pity...

what_he_said++;

Hmmm... you should name a date. The first day of Spring doesn't start here
until 1st September.

Regards

Andrew

-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Thursday, 2 March 2006 06:48
To: Tony Caduto
Cc: pgsql-general@postgresql.org
Subject: Re: Special offer with a possible dontation to the project

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tony Caduto
Sent: 01 March 2006 19:44
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Special offer with a possible dontation to
the project

Our goal is to reach 1000 sales by the first day of spring,

You might want to name a date for that - the first day of spring is just
ending here :-)

Regards, Dave.