MySQL to Postgres

A few reminders for myself when using Postgres (this is not a guide for anyone else, just my own cheat sheet).

desribe tablename:
\\d+ tablename

show tables:
select tablename from pg_tables;
(also shows many tables relating to postgres structural stuff).

show databases:
select datname from pg_database;

use databasename:
\\c databasename

auto_increment:
Define column type as SERIAL.

Leave a Reply