postgres学习总结

第一个建表语句：

DROP TABLE IF EXISTS "public"."eshop_city";
CREATE TABLE "public"."eshop_city" (
  "id" serial8 NOT NULL PRIMARY KEY,
  "del_flag" int2,
  "create_user" int4,
  "update_user" int4,
  "create_time" timestamp(6) NOT NULL,
  "update_time" timestamp(6)
)
;
COMMENT ON COLUMN "public"."eshop_city"."id" IS '全国城市表主键id';
COMMENT ON COLUMN "public"."eshop_city"."del_flag" IS '是否软删除：0;否，1:是';
COMMENT ON COLUMN "public"."eshop_city"."create_user" IS '创建用户id';
COMMENT ON COLUMN "public"."eshop_city"."update_user" IS '更新用户id';
COMMENT ON COLUMN "public"."eshop_city"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."eshop_city"."update_time" IS '更新时间';
COMMENT ON TABLE "public"."eshop_city" IS '全国城市表';

查询表结构
select tablename from pg_tables where schemaname='public'

用navicat12看不到postgre数据库里的表
更新navicat12到15就可以了

查询字符集与字符串转码

select pg_encoding_to_char(encoding) from pg_database where datname = 'picchealth-eshop';

学习文档：

http://www.postgres.cn/v2/document

https://www.runoob.com/postgresql/postgresql-data-type.html