Re: How can I display the contents of a function?

Another reason to look forward to 8.4. :)

Does that function return information in an identical way to selecting from
pg_proc?

2009/1/19 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>

> In response to Thom Brown :
> > Thanks everyone! I looked around the user-defined functions section of
> the
> > documentation, but there wasn't any mention of this. I'm sure others
> would
> > find it useful if it were included, or at least referenced to.
>
> Just for info:
>
> wait for the upcoming new release 8.4, it contains a function called
> pg_get_functiondef(). Example:
>
> test=# create or replace function foo(in a int) returns int as $$begin
> return a*10; end; $$language plpgsql;
> CREATE FUNCTION
> test=# select pg_get_functiondef('foo'::regproc);
> pg_get_functiondef
> --------------------------------------------------
> CREATE OR REPLACE FUNCTION public.foo(a integer)
> RETURNS integer
> LANGUAGE plpgsql
> AS $function$begin return a*10; end; $function$
>
> (1 row)
>
>
> http://developer.postgresql.org/pgdocs/postgres/functions-info.html
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>