PostgreSQL的使用

create user test_user with password '123456';

drop user test_user;

create tablespace test_tab owner test_user location '/data/pgsql/tablespaces/test_tab';

mkdir /data/pgsql/data/test_tab

grant create on tablespace test_tab to test_user2;

alter table test_tab set tablespace test_tab2;

drop tablespace test_tab;
drop tablespace if exists test_tab;

create database test_db;
create database test_db tablespace test_user;
create database test_db with owner test_user tablespace test_tab;

drop database "test_db";

alter database "test_db" set tablespace test_tab2

create schema test_schema;

drop schema test_schema;

grant all on database "test_db" to test_user;

grant all on all tables in schema test_schema to test_user;

DROP DATABASE test_db;

ERROR:  database "test_db" is being accessed by other users
DETAIL:  There are 3 other sessions using the database.

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='test_db' AND pid<>pg_backend_pid();