pgsql 总结

1. 查看当前自增字段的初始值

select setval('g_sch_csig_jjdata.t_profit_rate_kpi_id_seq', max(id)) from t_profit_rate_kpi;

2. 将自增字段初始值重置

TRUNCATE t_profit_rate_kpi RESTART IDENTITY;

3. mysql 数据导出

mysqldump -h[host] -u[用户名] -P[端口] -p [数据库] [表] > ./dump.sql

4. pgsql 添加自增主键

ALTER TABLE [表名] ADD COLUMN id serial primary key;