> Any help in getting function argument names is appreciated. Thank you
take a look at pg_catalog.pg_get_function_arguments(oid)
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gen
audit(v_IncidentId,'Modified',v_Message);
RETURN;
END; $BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION oms.om_change_i_division(integer, text, text) OWNER TO
oru;
From: Raghavendra [mailto:raghavendra@enterprisedb.com]
Sent: Wednesday, February 15, 2012 1
sql-general@postgresql.org
Subject: Re: [GENERAL] Dump functions alone
One more thing you can also get it from pg_get_functiondef() system
function.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra
wrote
One more thing you can also get it from pg_get_functiondef() system
function.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> You have two options.
>
>- Use contri
You have two options.
- Use contrib module pg_extractor
https://github.com/omniti-labs/pg_extractor
- Use pg_proc catalog to get function definition
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra
Hello all- Is there a way to just dump functions in a schema in to a
txt file/ sql file ? Thank you.
On Sat, Apr 29, 2006 at 12:00:15AM +0200, Dany De Bontridder wrote:
> Hello, I would like to dump all my functions and only the functions from a
> database, how can I do that ??
>
> So far, I can only get it with
>
> pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'
There's
Hello, I would like to dump all my functions and only the functions from a
database, how can I do that ??
So far, I can only get it with
pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'
Regards,
D.
---(end of broadcast)---
T
