zzh@ZZHPC:~$ sudo apt install postgresql-client
zzh@ZZHPC:~$ psql --version psql (PostgreSQL) 14.9 (Ubuntu 14.9-0ubuntu0.22.04.1)
zzh@ZZHPC:~$ psql postgresql://root:aaa@localhost:5432/zimple_bank psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1), server 16.1) WARNING: psql major version 14, server major version 16. Some psql features might not work. Type "help" for help. zimple_bank=# \q zzh@ZZHPC:~$ psql postgresql://root:aaa@localhost:5432/zimple_bank?sslmode=disable psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1), server 16.1) WARNING: psql major version 14, server major version 16. Some psql features might not work. Type "help" for help. zimple_bank=#
zzh@ZZHPC:/zdata/Github/zimplebank/db/scripts$ psql postgresql://root:aaa@localhost:5432/zimple_bank -f 0001_init_schema.up.sql CREATE TABLE CREATE TABLE CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX COMMENT COMMENT ALTER TABLE ALTER TABLE ALTER TABLE
标签:psql,INDEX,Execute,PostgreSQL,CREATE,14.9,ZZHPC,TABLE From: https://www.cnblogs.com/zhangzhihui/p/17860391.html