Miguel Ventura's blog : From MySQL to PostgreSQL

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*