postgreSQL command line

:sql:

• Connecting: psql -d postgres

• List databases: \l

• Connect to database: \c <database>

• (d)escribe (t)ables: \dt

• table details: \d <table> and \d+ <table>

Resources

• https://benjiweber.co.uk/blog/2021/03/21/thinking-in-questions-with-sql/