PostgesSQL

Online Postgest testing

• crunchydata playground
• Supabase WASM

Cheatsheet

https://tomcam.github.io/postgres/#opening-a-connection-locally

https://www.geeksforgeeks.org/postgresql-psql-commands/

Basic commands

psql -d database -U user -W =  connect to database user specific user

psql -V       = version

\?            = help

\conninfo     = connection information

\l            = list databases

\dt           = list tables

\du           = display users

\s            = display command history

\i            = execute file

\H            = switch to HTML

\q            = quit

Dockers

https://www.docker.com/blog/how-to-use-the-postgres-docker-official-image/ 

https://www.baeldung.com/ops/postgresql-docker-setup

https://www.sqlshack.com/getting-started-with-postgresql-on-docker/ 

https://www.bytebase.com/blog/how-to-set-up-postgres-using-docker/

docker exec -it mypostgres psql -h localhost -U postgres