RE: extracting the sql for a function

Hello

> -----Original Message-----
> From: Paul Tilles [mailto:paul(dot)tilles(at)noaa(dot)gov]
> Sent: Donnerstag, 23. August 2018 19:18
> To: pgsql-general(at)postgresql(dot)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