Обсуждение: 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
-----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.
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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!