*>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, 2018 at 2:53 PM Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > 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 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 > > > > -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
