Postgres Pro
Downloads
Home   >   mailing lists

Where are PL/pgsql definitions kept? - Mailing list pgsql-general

From Jerry LeVan
Subject Where are PL/pgsql definitions kept?
Date
Msg-id 9D84CED4-7461-11D8-BE0D-000393779D9C@eku.edu
Whole thread Raw
Responses Re: Where are PL/pgsql definitions kept?
List pgsql-general
Tree view 
Hi,
I just upgraded to 7.4.2 today...I have started looking at PL/PGsql
functions
and noticed that the pg_dumpall and pg_dump commands are able to
recover the
text for the function definitions.

I have examined ( I think ) every table in my catalog and have not been
able
to find the text definition of my PL/PGsql function.

Is it possible to recover the text of a function definition from within
postgresql?

Thanks,

Jerry

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: What is the syntax for UPDATE from one table to another?
Next
From: Richard Huxton
Date:
Subject: Re: Where are PL/pgsql definitions kept?