PostgreSQL

Meta Commands Commands

psql meta commands (backslash commands) provide quick access to database information and control. Master these shortcuts to navigate databases efficiently.

10 commands

Pro Tips

Add '+' to meta commands (e.g., \dt+) for more detailed output.

Most commands accept patterns: \dt user* lists tables starting with 'user'.

Commands

List databases

$ \l

List all databases.

Connect to database

$ \c dbname

Switch to another database.

List tables

$ \dt

List tables in current schema.

List all tables

$ \dt *.*

List tables in all schemas.

Describe table

$ \d tablename

Show table structure.

List schemas

$ \dn

List all schemas.

List indexes

$ \di

List indexes.

List functions

$ \df

List functions.

List roles

$ \du

List users/roles.

Show search path

$ SHOW search_path;

Display current schema search path.