Tables are automatically dropped ;
select 'drop table "' || tablename || '" cascade;' from pg_tables where schemaname = 'public';
Sequences are automatically dropped ;
SELECT 'drop sequence ' || c.relname || ';' FROM pg_class c where relname like 'myprefix%'
Show the current database
select current_database();
Show backend server version
select version();
Show the current user
select current_user;
Show the session user
select session_user;
kill an association
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE procpid <> pg_backend_pid();
select 'drop table "' || tablename || '" cascade;' from pg_tables where schemaname = 'public';
Sequences are automatically dropped ;
SELECT 'drop sequence ' || c.relname || ';' FROM pg_class c where relname like 'myprefix%'
Show the current database
select current_database();
Show backend server version
select version();
Show the current user
select current_user;
Show the session user
select session_user;
kill an association
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE procpid <> pg_backend_pid();
Comments
Post a Comment