-----Original Message----- From: Paul Tilles [mailto:paul.tilles@xxxxxxxx] Sent: Thursday, August 23, 2018 1:18 PM To: pgsql-general@xxxxxxxxxxxxxx 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
