Thread: Patch for pg_dump

I often need  in command line to get the code of function, so I make a patch for pg_dump, thanks this patch pg_dump is able to dump only one functions or all the functions.

The argument is --object or -B

Example:
./pg_dump -Bfunction:test_it -Bfunction:dblink_open
To dump the functions  test_it, dblink_open
./pgdump --object=function or pg_dump -Bfunction to dump only the functions


It is possible to add other objects, (see getObject functions)


I hope you'll find it interesting.

Regards,

.D.

(patch under BSD licence)

This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

Dany DeBontridder wrote:
> I often need  in command line to get the code of function, so I make a patch
> for pg_dump, thanks this patch pg_dump is able to dump only one functions or
> all the functions.
> 
> The argument is --object or -B
> 
> Example:
> ./pg_dump -Bfunction:test_it -Bfunction:dblink_open
> To dump the functions  test_it, dblink_open
> ./pgdump --object=function or pg_dump -Bfunction to dump only the functions
> 
> 
> It is possible to add other objects, (see getObject functions)
> 
> 
> I hope you'll find it interesting.
> 
> Regards,
> 
> .D.
> 
> (patch under BSD licence)

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +