Search Postgresql Archives

Re: Quering complete PLPGSQL code

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <nestorjb@xxxxxxxxx> wrote:
Thanks a lot that worked!!!


On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers <gsievers19@xxxxxxxxxxx> wrote:
Néstor Boscán <nestorjb@xxxxxxxxx> 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.consulting@xxxxxxxxxxx
p: 312.241.7800



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux