>_ linuxcommand.dev

Startseite › psql

psql

PostgreSQL Interactive Client

Ubuntu CentOS Debian SUSE Fedora RHEL

Syntax

$psql [options] [database [username]]

Optionen

-U

-d

-h

-p

-c

-f

Examples

Examples

$psql -U postgres

Examples

$psql -U user -d database

Examples

$psql -c "SELECT * FROM users;" database

Examples

$psql -f script.sql database

See also

pg_dump pg_restore createdb dropdb

Typical use cases

Manage PostgreSQL databases

Run SQL queries

Run scripts

Note PostgreSQL Command Line Client.

Export