Re: Quering complete PLPGSQL code
| От | Néstor Boscán |
|---|---|
| Тема | Re: Quering complete PLPGSQL code |
| Дата | |
| Msg-id | CALyLaQ+v_yr0yaWDW6jtLx=1RHGBy95ajb0+UM=3TCWJmm1Skg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Quering complete PLPGSQL code (Néstor Boscán <nestorjb@gmail.com>) |
| Список | pgsql-general |
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@gmail.com> wrote:
Thanks a lot that worked!!!On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers <gsievers19@comcast.net> wrote:pg_get_functiondef(oid)Néstor Boscán <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?
>
> Regards,
>
> NÊstor
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
В списке pgsql-general по дате отправления: