Re: 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,