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
