I recently migrated all my projects from MySQL to Postgresql. These are just some notes to serve as memory aids for me.
I'll keep adding things as I need to recall them.
| MySQL | PostgreSQL |
|---|---|
| show tables | \dt; |
| use *db* | \c *db* |
| show columns from *table* | \d *table* |