pg命令行操作

docker 进入命令行:

命令:

docker exec -ti adf8 /bin/bash

su postgres;
psql -U postgres

配置修改

修改docker pg的密码

参考文档: https://blog.csdn.net/qq_41123533/article/details/108482665

进入容器：docker exec -it ec2143b01d5a bash

使用postgres登录：su postgres

连接数据库：psql -U postgres

修改postgres用户密码：Alter user postgres with password ‘123456’;

退出数据库连接：\q

数据库查看

参考文档: https://blog.csdn.net/Michael_Lbs/article/details/57509940

数据库

列出数据库

\l

或

select datname from pg_database;

切换数据库

\c 数据库名

数据表

列出当前数据库所有表

\dt 或 \d

或

select tablename from pg_tables;

select tablename from pg_tables where tablename not like 'pg%' and tablename not like 'sql%' order by tablename;

使用sql: 查询当前db所有的表信息( pg_tables时系统视图)

select * from pg_tables;

所有用户自定义的表:

select tablename from pg_tables where schemaname='public';

查看表结构

\d <tablename>

wl=# \d movie_info
                     Table "public.movie_info"
    Column    |       Type        | Collation | Nullable | Default 
--------------+-------------------+-----------+----------+---------
 id           | integer           |           | not null | 
 movie_id     | integer           |           | not null | 
 info_type_id | integer           |           | not null | 
 info         | character varying |           | not null | 
 note         | character varying |           |          | 
Indexes:
    "movie_info_pkey" PRIMARY KEY, btree (id)
    "info_type_id_movie_info" btree (info_type_id)
    "movie_id_movie_info" btree (movie_id)