Console
$ psql
Commands
- Show tables:
\dt - Show databases:
\l - Show columns of a table:
\d tableor\d+ table
Creating database
$ createdb databasename
$ psql
\dt\l\d table or \d+ table $ createdb databasename
Devhints.io cheatsheets is a collection of cheatsheets I've written over the years. Suggestions and corrections? Send them in. I'm Rico Sta. Cruz. Check out my Today I learned blog for more.