Here is compiled a list of commands to run in postgres console:
$ docker-compose exec db psql -Upostgres to run pg console. In my case, I am running it from docker and the user is postgres, no password.
$ \l Will list available databases
$ \c DATABASE_NAME allows you to switch between databases.
$ \d when connected to the database, list tables, views, and sequences.
$ \dt list tables only.
$ \d+ TABLE_NAME show description of the table:
Show columns name:
$ \t If queries show data but you don’t see table’s, this command will help to toggle that.