What's really strange is that the function is returning the code like this:
FUNCTION public."PRUEBA_FUNCION2"(p_1 integer, OUT p_2 integer, INOUT p_3 integer, VARIADIC p_4 integer[]) RETURNS SETOF record LANGUAGE plpgsql IMMUTABLE STRICT SECURITY DEFINER ROWS 200 AS $function$begin null; end;$function$ So the LANGUAGE, INMUTABLE, STRICT, options are written before the code instead of after the code. Regards, Néstor On Mon, Jul 14, 2014 at 8:07 PM, Néstor Boscán <nesto...@gmail.com> wrote: > Thanks a lot that worked!!! > > > On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers <gsiever...@comcast.net> > wrote: > >> Néstor Boscán <nesto...@gmail.com> writes: >> >> > Hi >> > >> > I want to get the PLPGSQL code from the PostgreSQL 9.1 database. I've >> used pg_proc that only gives me the body of the code. Is there a Postgres >> function that can build >> > all the code? >> >> pg_get_functiondef(oid) >> >> >> > >> > Regards, >> > >> > NÊstor >> > >> >> -- >> Jerry Sievers >> Postgres DBA/Development Consulting >> e: postgres.consult...@comcast.net >> p: 312.241.7800 >> > >
