You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
805 B
Plaintext
29 lines
805 B
Plaintext
# psql
|
|
# PostgreSQL command-line client.
|
|
|
|
# Connect to database.
|
|
# It connects to localhost using default port 5432
|
|
# with default user as currently logged in user
|
|
psql database
|
|
|
|
# Connect to database on given server host running on given port
|
|
# with given username, without a password prompt
|
|
psql -h host -p port -U username database
|
|
|
|
# Connect to database; user will be prompted for password
|
|
psql -h host -p port -U username -W database
|
|
|
|
# Execute a single SQL query or PostgreSQL command
|
|
# on the given database (useful in shell scripts)
|
|
psql -c 'query' database
|
|
|
|
# Execute commands from a file on the given database
|
|
psql database -f file.sql
|
|
|
|
# See also:
|
|
# pg_dump, pg_restore, pg_top
|
|
# PostgreSQL cheat sheets at /psql/
|
|
# list of pages: /psql/:list
|
|
# search in pages: /psql/~keyword
|
|
|