Postpresql笔记

查看约束

SELECT constraint_name, column_name
FROM information_schema.key_column_usage
WHERE table_name = 'your_table_name' 

删除约束

ALTER TABLE target_table DROP CONSTRAINT constraint_name;

设置主键递增

CREATE SEQUENCE admin_id_seq;

已有表
ALTER TABLE "public"."t_student" ALTER COLUMN "id" SET DEFAULT 
nextval('t_student_id_seq'::regclass);
建表
CREATE TABLE "admin" (
  "id" int4 NOT NULL DEFAULT nextval('admin_id_seq'::regclass),
  CONSTRAINT "admin_pkey" PRIMARY KEY ("id")
);