查看所有表及备注
WITH T2 AS(
SELECT relname AS c_table_name, CAST(obj_description(relfilenode,'pg_class') AS VARCHAR) AS c_comment
FROM pg_class
)
SELECT tableowner AS t_owner,schemaname AS t_schema,tablename AS t_name,T2.*
FROM pg_tables AS T1
LEFT JOIN T2 ON T2.c_table_name = T1.tablename
WHERE T1.tablename NOT LIKE 'pg_%'
AND T1.schemaname IN ('schema_xxxx','schema_xxxx','schema_xxxx')
PostgreSQL 创建类似 MySQL 自增主键
-- CREATE SEQUENCE sys_user_userid_seq INCREMENT 1 START 100 MINVALUE 100 MAXVALUE 99999999 CACHE 1;
alter table sys_user alter column user_id set default nextval('sys_user_userid_seq');
PostgreSQL 返回其参数中第一个非空表达式 COALESCE
select COALESCE(null,null,’0′)
string_agg
select string_agg(col,',') ,cola from table_a group by cola
SELECT * FROM table01 WHERE col01= ANY(STRING_TO_ARRAY('aaaa,sss,bbb',','))