How to access postgreSQL in CLI

Assumption:

item value
postgreSQL server localhost:5432
username user1
password pass1
database db1

Command:

PGPASSWORD=pass1 psql -h localhost -p 5432 -U user1 -d db1
Posted on 2022-03-22
Navigator
Related Articles
  1. JSON_AS_ASCII no longer works after upgrading Flask
  2. Increase line width limit to python code when using VS Code and flake8
  3. Get rid of annoying warnings like F403 and F405 when using VS Code and flake8
Related Tags
sql