Cacher is the code snippet organizer for pro developers

https://www.postgresql.org/docs/current/static/app-psql.html

\d+ tablename
\list or \l: list all databases
\dt: list all tables in the current database
\connect database_name