extracting the sql for a function

-----Original Message-----
From: Paul Tilles [mailto:paul.tilles@noaa.gov]
Sent: Thursday, August 23, 2018 1:18 PM
To: pgsql-general@postgresql.org
Subject: extracting the sql for a function

WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE risks.

Using postgres Version 9.5

I can extract the sql for a table using

pg_dump -d database_name -s -t table_name -f table_name.sql

Is there something equivalent for extracting the sql for a function from the database?

Paul Tilles

__________________________________________________________________________________________________________

select prosrc from pg_proc where proname = 'function_name';

You can pronamespace to WHERE clause to specify schema.

Regards,
Igor Neyman

Hello

-----Original Message-----
From: Paul Tilles [mailto:paul.tilles@noaa.gov]
Sent: Donnerstag, 23. August 2018 19:18
To: pgsql-general@postgresql.org
Subject: extracting the sql for a function

Using postgres Version 9.5

I can extract the sql for a table using

pg_dump -d database_name -s -t table_name -f table_name.sql

Is there something equivalent for extracting the sql for a function from the database?

Paul Tilles

I don't know if there is but you can get the function definition:

SELECT * FROM pg_get_functiondef('functionname'::regproc);

or

SELECT * FROM pg_get_functiondef('functionname(list of parameters data types)'::regprocedure);

If you want to export you may use the -t and -o switches.

Regards
Charles

*>is there something equivalent for extracting the sql for a function from
the database? *

*Have a look at pg_extractor. It is essentially a pg_dump but with many
more options.*

*https://github.com/omniti-labs/pg_extractor
<https://github.com/omniti-labs/pg_extractor&gt;*

On Thu, Aug 23, 2018 at 2:53 PM Charles Clavadetscher <
clavadetscher@swisspug.org> wrote:

Hello

-----Original Message-----
From: Paul Tilles [mailto:paul.tilles@noaa.gov]
Sent: Donnerstag, 23. August 2018 19:18
To: pgsql-general@postgresql.org
Subject: extracting the sql for a function

Using postgres Version 9.5

I can extract the sql for a table using

pg_dump -d database_name -s -t table_name -f table_name.sql

Is there something equivalent for extracting the sql for a function from

the database?

Paul Tilles

I don't know if there is but you can get the function definition:

SELECT * FROM pg_get_functiondef('functionname'::regproc);

or

SELECT * FROM pg_get_functiondef('functionname(list of parameters data
types)'::regprocedure);

If you want to export you may use the -t and -o switches.

Regards
Charles

--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!