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 <nesto...@gmail.com
<mailto:nesto...@gmail.com>> wrote:
Thanks a lot that worked!!!
On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers
<gsiever...@comcast.net <mailto:gsiever...@comcast.net>> wrote:
Néstor Boscán <nesto...@gmail.com <mailto: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
<mailto:postgres.consult...@comcast.net>
p: 312.241.7800 <tel:312.241.7800>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
