Re: Quering complete PLPGSQL code

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Mon, 14 Jul 2014 20:10:56 -0700

On 07/14/2014 07:15 PM, Néstor Boscán wrote:
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.

That is acceptable. In fact that is what you see if you use \ef in psql:

CREATE FUNCTION ( )
 RETURNS
 LANGUAGE
 -- common options:  IMMUTABLE  STABLE  STRICT  SECURITY DEFINER
AS $function$

$function$

Regards,

Néstor

On Mon, Jul 14, 2014 at 8:07 PM, Néstor Boscán <nestorjb@xxxxxxxxx
<mailto:nestorjb@xxxxxxxxx>> wrote:

    Thanks a lot that worked!!!

    On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers
    <gsievers19@xxxxxxxxxxx <mailto:gsievers19@xxxxxxxxxxx>> wrote:

        Néstor Boscán <nestorjb@xxxxxxxxx <mailto: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
        <mailto:postgres.consulting@xxxxxxxxxxx>
        p: 312.241.7800 <tel:312.241.7800>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx