大前端

前端学习之家-大前端

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

List all databases on the server, their owners, and user access levels


# \c <dbname>

Connect to a database named


# \dt

Show database tables


# \d <tablename>

Describe table schema


# \q

Quit psql, return to the terminal


# \?

Get help, see list of available commands.

发表评论:

Copyright Your WebSite.Some Rights Reserved.