Re: display function code - Mailing list pgsql-admin

From Tom Lane
Subject Re: display function code
Date
Msg-id 10184.1128304120@sss.pgh.pa.us
Whole thread Raw
In response to Re: display function code  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Colton A Smith wrote:
>> I wrote a function for my database and 'loaded' it, but then
>> misplaced the code.  Is there a query I can issue to retrieve it?

> psql \df+?  That works for non-C languages.

Also, consider doing "pg_dump -s yourdb" and then pulling the CREATE
FUNCTION entry out of the dump script.

            regards, tom lane

pgsql-admin by date:

Previous
From: Andreas Pflug
Date:
Subject: pgAdmin guru hints
Next
From: Tom Lane
Date:
Subject: Re: Vacuum Full Analyze Stalled