> -----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.