Skip to Content

PostgreSql

Connect to PostgreSql

psql -h <hostname> -p <port> -U <username> -d <database> psql -h myhost -p 5432 -U myapplicationuser -d applicationdb
  • With host
postgresql://<username>:<password>@<hostname>:<port>/<database> psql postgresql://myapplicationuser:mypass@myhost:1234/applicationdb

Basic usage

List all database

\l

Connect to specific database

\c <db_name> \c users

List all tables in database

\d

List all details with the tables

\d+ <table_name>

Delete stuff

Delete database

DROP DATABASE <database_name>;

Delete tables

DROP TABLE <table_name>;

Create user

CREATE USER <user_name> WITH PASSWORD '<user_password>' SUPERUSER; ALTER ROLE <user_name> WITH LOGIN;

Exit

quit
Last updated on