Where are PL/pgsql definitions kept?

From: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Where are PL/pgsql definitions kept?
Date: 2004-03-12 20:12:41
Message-ID: 9D84CED4-7461-11D8-BE0D-000393779D9C@eku.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-03-12 20:47:31 Re: Where are PL/pgsql definitions kept?
Previous Message Bruno Wolff III 2004-03-12 18:32:06 Re: What is the syntax for UPDATE from one table to another?