RE: extracting the sql for a function

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