• 切換數(shù)據(jù)庫
  \c databaseName

• 查看數(shù)據(jù)庫、表、索引
  postgres=# \l 數(shù)據(jù)庫； \dt 表； \di 索引；

• 查看庫、表大小

select pg_database.datname, pg_database_size(pg_database.datname) AS size from pg_database; 
或
 select pg_size_pretty(pg_database_size('databaseName'));
或
select pg_size_pretty(pg_tablespace_size('tableName')); 

• 修改自增索引起始
  select setval('code_configs_id_seq',10,false);

• 數(shù)組類型分列
  unnest(anyarray)
jsonb_array_elements('[{a:1},{a:2}]')

• 截圖字符串
  select split_part(substring('/api/index?AA&channel=00&fefefe' from '%#"channel%&?#"%' for '#'),'&',1);

• 替換
  update temp set name = replace(name,'_','')

• 刪除約束
  ALTER TABLE table_name DROP CONSTRAINT some_name;

• 查看權(quán)限
  select * from information_schema.table_privileges where grantee='user_name';

• 時間
  to_date(to_char(orderd + interval '8 hours','YYYYMMDD'),'YYYYMMDD')