PostgreSQL

pgsql建表语句

sql

-- 建表
DROP TABLE IF EXISTS "t_user";
CREATE TABLE "t_user" (
  "id" 					SERIAL NOT NULL,
  "nick_name" 	        VARCHAR (20),
  "real_name" 	        VARCHAR (20),
  "avatar" 			    VARCHAR (255),
  "birthday" 			DATE,
  "gender"              CHAR(1),
  "phone" 			    VARCHAR (20),
  "e_mail" 			    VARCHAR (20),
  "address" 		    VARCHAR (255),
  "state" 			    SMALLINT,
  "dept_id"             INTEGER,
  "inner"               SMALLINT,
  "create_time"         TIMESTAMP,
  "update_time"         TIMESTAMP,
  PRIMARY KEY ("id")
);
-- 注释
COMMENT ON TABLE "t_user" IS '用户信息表';
COMMENT ON COLUMN "t_user"."id" IS '主键';
COMMENT ON COLUMN "t_user"."nick_name" IS '昵称';
COMMENT ON COLUMN "t_user"."real_name" IS '名字';
COMMENT ON COLUMN "t_user"."avatar" IS '头像';
COMMENT ON COLUMN "t_user"."birthday" IS '生日';
COMMENT ON COLUMN "t_user"."gender" IS '性别(M-男，F-女)';
COMMENT ON COLUMN "t_user"."phone" IS '手机号';
COMMENT ON COLUMN "t_user"."e_mail" IS '邮箱地址';
COMMENT ON COLUMN "t_user"."address" IS '联系地址';
COMMENT ON COLUMN "t_user"."state" IS '状态(0-异常，1-正常)';
COMMENT ON COLUMN "t_user"."create_time" IS '创建时间';
COMMENT ON COLUMN "t_user"."update_time" IS '更新时间';

INSERT INTO t_user ( nick_name, real_name, avatar, birthday, phone, e_mail, address, state, create_time, update_time )
VALUES( 'biubiu', '张三', NULL, '1999-12-26', '13825274863', 'baijqmail@163.com', '陕西西安雁塔区', 1, NOW( ), NOW( ) )

pgsql驱动

xml

<!--postgresql-->
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <scope>runtime</scope>
</dependency>

pgsql配置

yaml

spring:
  datasource:
    url: jdbc:postgresql://192.168.198.128:5432/ufs
    username: root
    password: root
    driver-class-name: org.postgresql.Driver

PostgreSQL ​

PostgreSQL