Postgres Cheatsheet #postgres #ubuntu

postgres.md

psql

Connect to Database

\c [databasename]

Display Tables

\dt

Display Rows

SELECT * FROM [tablename]

or

table [tablename]

pg_restore to dockerized postgres

cat ~/TEMP/dvdrental.tar | docker exec -i dev-postgres pg_restore -U postgres -d dvdrental

src: https://www.postgresqltutorial.com/load-postgresql-sample-database/ & https://stackoverflow.com/a/63435830/2823589