PostgreSQL psql 终端命令

1. 命令行登录数据库

$ psql -U username -h ipaddress -d dbname

1. 在命令行下切换数据库

wzz=# \c dbname 

1. 查看帮助

wzz=# helpYou are using psql, the command-line interface to PostgreSQL.Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands       \g or terminate with semicolon to execute query       \q to quit

---

常用命令

. 列出所有的数据库

wzz=# \l Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   -----------+----------+----------+-------------+-------------+----------------------- postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |  template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +           |          |          |             |             | postgres=CTc/postgres template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +           |          |          |             |             | postgres=CTc/postgres wzz       | wzz      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | (4 rows)

. 切换数据库

wzz=# \c dbname

. 列出当前书库库下的表

wzz=# \d

. 显示当前数据库

wzz=# select current_database();

. 列出表的所有字段

wzz=# \d tablename

. 查看表的基本情况

wzz=# \d+ tablename

. 退出登录

wzz=# \q

. 退出登录

wzz=# \q