Re: Quering complete PLPGSQL code

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@gmail.com
> <mailto:nestorjb@gmail.com>> wrote:
>
>     Thanks a lot that worked!!!
>
>
>     On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers
>     <gsievers19@comcast.net <mailto:gsievers19@comcast.net>> wrote:
>
>         Néstor Boscán <nestorjb@gmail.com <mailto:nestorjb@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.consulting@comcast.net
>         <mailto:postgres.consulting@comcast.net>
>         p: 312.241.7800 <tel:312.241.7800>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com