随笔分类 - Postgre
摘要：创建范围分区表 # 创建分区表 主表 CREATE TABLE person_1 ( id SERIAL NOT NULL, name VARCHAR NOT NULL, begin_time TIMESTAMP, end_time TIMESTAMP ) PARTITION BY RANGE (b
阅读全文
摘要：查询当前连接信息 SELECT pid, usename, application_name, client_addr, query, state FROM pg_stat_activity WHERE datname = 'mynewdatabase'; 删除除当前连接之外的其它连接 SELECT
阅读全文
