Hi,
I'm working to implement a new feature to pg_dump: the ability to dump
objects like function, indexes... And I notice that there some usefull
functions like pg_malloc, pg_calloc... So I've added pg_free to avoid the
sequence if-not-null-free-point-to-NULL, now I'd like to add a function
On 4/13/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:
Dany DeBontridder wrote:
I'm working to implement a new feature to pg_dump: the ability to dump
objects like function, indexes...
pg_dump already dumps functions and indexes.
Right but you can't dump only one or two functions
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
Here is a (small) patch to give the ability to pg_dump to export only the
functions (or only one), very useful when you often develop with psql (
postgresql.8.2.3)
Usage:
pg_dump -Q function_name DATABASE export function_name
pg_dump -QDATABASE export all the functions
Sorry I forgot the attach :-)
It is not perfect so bear with me, it is my first try.
Regards,
D.
On 3/21/07, Bruce Momjian [EMAIL PROTECTED] wrote:
And the patch is so small, it is invisible (missing). ;-)
---
Dany
On 3/21/07, Tom Lane [EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I guess this matches this TODO item:
o Allow selection of individual object(s) of all types, not just
tables
(...)
Code-wise, the patch seems a bit of a mess too --- it will certainly not