PostgreSQL: Script to List Functions You can list all user-defined and system functions in PostgreSQL using system catalogs. List Functions in Current Database SELECT routine_name FROM information_schema.routines WHERE routine_type = 'FUNCTION' AND routine_schema = 'public'; List Functions with Definition SELECT proname, pg_get_functiondef(p.oid) FROM pg_proc p JOIN pg_namespace n ON n.oid = p.pronamespace WHERE n.nspname = 'public'; This is helpful when auditing or documenting database logic.

PostgreSQL: Script to Drop Foreign Keys Sometimes you may need to drop foreign key constraints while restructuring tables. PostgreSQL allows you to do this easily. Drop a Specific Foreign Key ALTER TABLE orders DROP CONSTRAINT orders_customer_id_fkey; Drop All Foreign Keys in a Schema SELECT 'ALTER TABLE ' || tc.table_name || ' DROP CONSTRAINT ' || tc.constraint_name || ';' FROM information_schema.table_constraints tc WHERE tc.constraint_type = 'FOREIGN KEY' AND tc.table_schema = 'public'; Run the generated statements to remove all foreign keys.