Обсуждение: Dumping functions
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
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
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
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++;