数据库操作

我的数据库操作

执行sql文件

pg_restore -U qiao -d test /home/qiao/qiao_bak.sql

查看数据库内存等信息

SELECT d.datname AS Name,  pg_catalog.pg_get_userbyid(d.datdba) AS Owner,
  CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
      THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
      ELSE 'No Access'
  END AS SIZE
FROM pg_catalog.pg_database d
  ORDER BY
  CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
      THEN pg_catalog.pg_database_size(d.datname)
      ELSE NULL
  END DESC -- nulls first
  LIMIT 20

为数据库中已有的字段重命名

alter table  表名 rename  column 列名  to new表名
alter table user rename column name to name_1

获取自增

-- 查找当前数据库自增的id下一个值,以及设置最新的自增id为下一个值
select nextval('purchase_request_audit_id_seq');

SELECT currval('purchase_request_audit_id_seq');

SELECT setval('purchase_request_audit_id_seq', (SELECT max(id) FROM purchase_request_audit));