>_ linuxcommand.dev

Startseite › psql

Database

psql

PostgreSQL Interactive Client

Ubuntu CentOS Debian SUSE Fedora RHEL

Verified: 2026-03-04

Syntax

$psql [options] [database [username]]

Optionen

-U

-d

-h

-p

-c

-f

Examples

$psql -U postgres

$psql -U user -d database

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

$psql -f script.sql database

See also

pg_dump pg_restore createdb dropdb

Typical use cases

?

Standard usage

psql --help

Note PostgreSQL Command Line Client.

Export