Re: [BUGS] Regarding copy of function from one db to another db

HI, i think that is not a bug, try to execute that query, this return 
the code of functions  of specific schema (schema_name)


select 'CREATE OR REPLACE FUNCTION '|| 
nsp.nspname||'.'||proname||'('||pg_get_function_identity_arguments(p.oid)||') 
RETURNS ' ||

case
when proretset='t' THEN ' SETOF '
else ''
end || typname    || ' AS $BODY$ ' ||prosrc || ' $BODY$ LANGUAGE ' || 
l.lanname    ||';'      from pg_proc p   join pg_namespace nsp ON 
p.pronamespace = nsp.oid join pg_type t ON p.prorettype = t.oid join pg_language l ON p.prolang = l.oid where 
nsp.nspname = 'schema_name'



Greetings

PD: maybe use copy to export result and load in the other place

On 15/06/17 06:43, Rohit Dwivedi wrote:
> Hello sir,
>             if we need to copy all the functions of database to 
> another database then how  we can implement it other then copy paste 
> and run it...Because there are total 153 functions in our database.
>
> Please Reply Us.
>
> Thank u sir,



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs