How to backup all functions in pgadmin 4 version 1.6?
After executing the below query the backup functions stored in which place?
And how to find it?
How to know all information is backed up with what's being done?
SELECT pg_get_functiondef(f.oid) || E';\n'
FROM pg_proc f
JOIN pg_namespace n ON f.pronamespace = n.oid
WHERE n.nspname = 'schemaname';
Asked by M.Karthika
(21 rep)
Nov 29, 2017, 06:36 AM
Last activity: Apr 25, 2025, 07:03 PM
Last activity: Apr 25, 2025, 07:03 PM