psql 常用的命令

• psql is an interactive terminal application for connection and interacting with your local postgres server on your machine.
• Connect using $ psql
• psql lets you
  • Directly type and execute SQL commands to your database
  • Inspect and preview your database and database tables using psql meta-commands

Protip: type \ ? into psql to see a list of available commands

Useful basic psql commands

psql <dbname> [<username>]

Starts psql with a connection to dbname. Optionally use another user than current user.

---

In psql:

# \l

这个命令为了好记，字母 l 想成 list的缩写
List all databases on the server, their owners, and user access levels

---

# \c <dbname>

将字母 c 想成 connect的缩写
Connect to a database named

---

# \dt

将 dt 的原型想成 database table
Show database tables

---

# \d <tablename>

将 d 想成 describe
Describe table schema

---

# \q

将 q 想成 quit
Quit psql, return to the terminal

---

# \?

Get help, see list of available commands.