【Postgresql】常用命令

Connection

查看所有的连接

$ SELECT datid, datname, pid, usesysid, usename, application_name FROM pg_stat_activity;

---

查看字段:

查看字段名，字段类型，注释

$ select column_name, data_type, col_description((table_schema||'.'||table_name)::regclass::oid, ordinal_position) as column_comment from information_schema.columns  WHERE table_schema = 'public' and table_name = '';

查询日期时间范围:

# create_time is timestamp truncate to seconds
$ select to_timestamp(create_time) FROM <tableName> WHERE to_timestamp(create_time) BETWEEN '2021-12-28 00:00:00'::timestamp AND '2021-12-29 23:59:59'::timestamp;