Cheatsheet for Postgres
April 14th, 2007 at 6:53 pm (Programming)
MySQL Postgres Description
show databases; \l Lists all databases
show tables; \d Lists tables of a database
use db; \c db Connects to a database for use
desc table; \d table Displays table definition
n/a \z object View user/host/db permissions
tahooie said,
October 2, 2008 at 9:00 am
this totally saves my life.
*tahooie adds some keywords so that google will index this and the next poor sap will be able to find it:
psql commands
psql show databases
psql show tables
psql use database
psql desc table