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,
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 o
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
pg_st
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 certainl
issing). ;-)
---
Dany DeBontridder wrote:
> 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 fun
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
