postgres:
    image: postgres:15.3-alpine3.18
    restart: always
    environment:
      POSTGRES_PASSWORD: example
    ports:
      - 5432:5432
    volumes:
      - ${DATA_PATH}/postgres/data:/var/lib/postgresql/data
      - /etc/localtime:/etc/localtime:ro

  adminer:
    image: adminer
    restart: always
    ports:
      - 18080:8080

# 登录到postgres容器
docker-compose exec  postgres /bin/bash

# 登录到postgres ,为啥不要密码呢？
docker-compose exec  postgres psql -U postgres

# 创建数据库
postgres=# create database test;

# 进入数据库
postgres=# \c test;

# 退出当前数据库
test=# \c postgres

# 删除test数据库
postgres=# drop database test;

#
SELECT 'CREATE DATABASE test1' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'test1')\gexec

create table wk_student (
    student_id     BIGINT          NOT NULL     ,
    student_name   varchar(255)            NOT NULL                  ,
    student_age    int                                               ,
    student_sex    int                                               ,
    gmt_create    timestamp                DEFAULT CURRENT_TIMESTAMP NULL   ,
    gmt_modified  timestamp                DEFAULT CURRENT_TIMESTAMP NULL   ,
    PRIMARY KEY (student_id)
)

CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL,
   JOIN_DATE      DATE
);

test=# \d
           List of relations
 Schema |    Name    | Type  |  Owner
--------+------------+-------+----------
 public | company    | table | postgres
 public | wk_student | table | postgres
(2 rows)

test=# \d wk_student
                               Table "public.wk_student"
    Column    |            Type             | Collation | Nullable |      Default
--------------+-----------------------------+-----------+----------+-------------------
 student_id   | bigint                      |           | not null |
 student_name | character varying(255)      |           | not null |
 student_age  | integer                     |           |          |
 student_sex  | integer                     |           |          |
 gmt_create   | timestamp without time zone |           |          | CURRENT_TIMESTAMP
 gmt_modified | timestamp without time zone |           |          | CURRENT_TIMESTAMP
Indexes:
    "wk_student_pkey" PRIMARY KEY, btree (student_id)

test=# drop table company;
DROP TABLE
test=# \d
           List of relations
 Schema |    Name    | Type  |  Owner
--------+------------+-------+----------
 public | wk_student | table | postgres
(1 row)

test=# INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (1, 'Paul', 32, 'California', 20000.00,'2001-07-13');
INSERT 0 1

test=# INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (3, 'Teddy', 23, 'Norway', 20000.00, DEFAULT );


test=# INSERT INTO COMPANY (ID,NAME,AGE) VALUES (4, 'Jack', 23 );

test=# UPDATE COMPANY SET ADDRESS = 'Texas', SALARY=20000;

# 日期表达式返回当前系统的日期和时间
SELECT CURRENT_TIMESTAMP;

CREATE TABLE COMPANY3(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL UNIQUE,
   ADDRESS        CHAR(50),
   SALARY         REAL    DEFAULT 50000.00
);

CREATE TABLE tablename (
   colname SERIAL
);