MySQL vs PostgreSQL

Jump to: navigation, search

MySQL	Postgres
SHOW DATABASES;	\l
\u db	\c db
SHOW GRANTS;	\du
SHOW TABLES;	\dt
SHOW COLUMNS;	\d table
DESC tblname;	\d foo
USE dbname;	\c dbname
SHOW PROCESSLIST;	SELECT * FROM pg_stat_activity;
describe table;	\d+ table;
show schemas;	\dn OR select * from pg_namespace;
\G (one time effect)	\x (toggle for all queries)
\P pager	$PAGER
\T file	tee file
show create table tablename;	pg_dump --schema-only -t tablename (may not always work)

\e Edit buffer in external editor; vim by default. \! Execute shell command