Commands.app

PostgreSQL Commands

PostgreSQL database management commands and psql utilities

19 commands found
psql
PostgreSQL interactive terminal
Connection
psql -U postgres
createdb
Create a new PostgreSQL database
Database Management
createdb myapp
dropdb
Remove a PostgreSQL database
Database Management
dropdb myapp
pg_dump
Backup a PostgreSQL database
Backup & Restore
pg_dump mydb > backup.sql
pg_restore
Restore a PostgreSQL database from archive
Backup & Restore
pg_restore -d mydb backup.dump
pg_dumpall
Backup all PostgreSQL databases
Backup & Restore
pg_dumpall > all_databases.sql
createuser
Create a new PostgreSQL user
User Management
createuser myuser
dropuser
Remove a PostgreSQL user
User Management
dropuser myuser
\l
List all databases in psql
psql Commands
\l
\c
Connect to a database in psql
psql Commands
\c mydb
\dt
List tables in current database
psql Commands
\dt
\d
Describe table structure
psql Commands
\d users
\du
List PostgreSQL users/roles
psql Commands
\du
\i
Execute SQL from file in psql
psql Commands
\i script.sql
\timing
Toggle query execution timing
psql Commands
\timing
\x
Toggle expanded display mode
psql Commands
\x
vacuumdb
Garbage-collect and analyze PostgreSQL database
Maintenance
vacuumdb mydb
reindexdb
Rebuild PostgreSQL database indexes
Maintenance
reindexdb mydb
pg_ctl
Control PostgreSQL server
Server Control
pg_ctl start -D /var/lib/postgresql/data