Re: FUNCTION DEFINITION - Mailing list pgsql-general

From Richard Huxton
Subject Re: FUNCTION DEFINITION
Date
Msg-id 467C0149.3020400@archonet.com
Whole thread Raw
In response to FUNCTION DEFINITION  (ABHANG RANE <arane@indiana.edu>)
List pgsql-general
ABHANG RANE wrote:
> Hi,
> If I have created a plpgsql function, is there a way I can look again at
> the create statement of that function. I need to know what exactly is
> there in the function.

 From psql: \df+ my_function

 From command-line: pg_dump --schema-only my_database > my_db_dump.sql

Second one is easier to scroll through/edit.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: FUNCTION DEFINITION
Next
From: Erik Jones
Date:
Subject: Re: ORDER BY with exception