Shaikh Sonny Aman’s Blog

previously www.mailtoaman.com

PostgreSQL Cheat Sheet

CREATE DATABASE
CREATE DATABASE dbName;
CREATE TABLE (with auto numbering integer id)
CREATE TABLE tableName (id serial PRIMARY KEY,name varchar(50) UNIQUE NOT NULL,dateCreated timestamp DEFAULT current_timestamp);
Add a primary key
ALTER TABLE tableName ADD PRIMARY KEY (id);
Create an INDEX
CREATE UNIQUE INDEX indexName ON tableName (columnNames);
Backup a database (command line)
pg_dump dbName > dbName.sql
Backup all databases (command line)
pg_dumpall > pgbackup.sql
Run a SQL [...]

PostgreSQL Cheat Sheet

CREATE DATABASE
CREATE DATABASE dbName;
CREATE TABLE (with auto numbering integer id)
CREATE TABLE tableName (id serial PRIMARY KEY,name varchar(50) UNIQUE NOT NULL,dateCreated timestamp DEFAULT current_timestamp);
Add a primary key
ALTER TABLE tableName ADD PRIMARY KEY (id);
Create an INDEX
CREATE UNIQUE INDEX indexName ON tableName (columnNames);
Backup a database (command line)
pg_dump dbName > dbName.sql
Backup all databases (command line)
pg_dumpall > pgbackup.sql
Run a SQL [...]