Re: extracting the sql for a function

2018-08-23 Thread Melvin Davidson
*>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.* *https://github.com/omniti-labs/pg_extractor <https://github.com/omniti-labs/pg_extractor>* On Thu, Aug 23,

RE: extracting the sql for a function

2018-08-23 Thread Charles Clavadetscher
Hello > -Original Message- > From: Paul Tilles [mailto:paul.til...@noaa.gov] > Sent: Donnerstag, 23. August 2018 19:18 > To: pgsql-gene...@postgresql.org > Subject: extracting the sql for a function > > Using postgres Version 9.5 > > I can extract the sql for

RE: extracting the sql for a function

2018-08-23 Thread Igor Neyman
-Original Message- From: Paul Tilles [mailto:paul.til...@noaa.gov] Sent: Thursday, August 23, 2018 1:18 PM To: pgsql-gene...@postgresql.org Subject: extracting the sql for a function WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE

extracting the sql for a function

2018-08-23 Thread Paul Tilles
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