Postgres Client Setup

Installation

Ubuntu

sudo apt install -y postgresql-client

Amazon EC2 2023

sudo yum install -y postgresql15.x86_64

PSQL Commands

Running as postgres user

sudo -i -u postgres
# sudo --login --user postgres

Command format

PGPASSWORD=PASSWORD psql -h HOST -p PORT -U USERNAME -d DATABASE --no-password

psql -h HOST -p PORT -U USERNAME -d DATABASE --password
# Password:

psql postgresql://USERNAME:PASSWORD@HOST:5432/DATABASE?sslmode=require

Usage

Connect to shell

psql -h localhost -p 5432 -U postgres -d postgres --password
# Password:

Run query command

psql -h localhost -p 5432 -U postgres -d postgres -c 'QUERY'
psql -h localhost -p 5432 -U postgres -d postgres --command='QUERY'

Run query file

psql -h localhost -p 5432 -U postgres -d postgres -f FILENAME