pgsql创建表的sql语句
时间: 2023-10-08 16:09:19 浏览: 83
创建表的SQL语句如下:
```sql
DROP TABLE IF EXISTS "tb_test";
CREATE TABLE "public"."tb_test" (
"id" SERIAL8 NOT NULL,
"username" varchar(50) COLLATE "pg_catalog"."default",
"password" varchar(50) COLLATE "pg_catalog"."default",
"conclusion" varchar(50) COLLATE "pg_catalog"."default",
"picture" varchar(255) COLLATE "pg_catalog"."default",
"ext1" varchar(255) COLLATE "pg_catalog"."default",
"create_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY ("id")
);
COMMENT ON COLUMN "public"."tb_test"."id" IS '主键';
COMMENT ON COLUMN "public"."tb_test"."username" IS '用户名';
COMMENT ON COLUMN "public"."tb_test"."password" IS '密码';
COMMENT ON COLUMN "public"."tb_test"."conclusion" IS '结论';
COMMENT ON COLUMN "public"."tb_test"."picture" IS '图片';
COMMENT ON COLUMN "public"."tb_test"."ext1" IS '扩展字段1';
COMMENT ON COLUMN "public"."tb_test"."create_time" IS '创建时间';
COMMENT ON TABLE "public"."tb_test" IS '测试表';
```
其中,使用`CREATE TABLE`语句创建表,并指定了表名为`tb_test`。表中的字段包括`id`,`username`,`password`,`conclusion`,`picture`,`ext1`和`create_time`。其中,`id`字段是主键,并使用`SERIAL8`类型表示自增。其他字段的类型为`varchar`,长度分别为50和255。`create_time`字段使用`timestamp`类型,并设置了默认值为当前时间戳。使用`COMMENT ON COLUMN`语句为每个字段添加了注释。最后,使用`COMMENT ON TABLE`语句为表添加了注释。