postgresql 9.4

adminpack auth_delay auto_explain btree_gin btree_gist chkpass citext cube dict_int dict_xsyn dummy_seclabel earthdistance file_fdw fuzzystrmatch hstore intagg intarray isn lo ltree pageinspect passwordcheck pgcrypto pgrowlocks pgstattuple pg_buffercache pg_freespacemap pg_prewarm pg_stat_statements pg_trgm postgres_fdw seg sepgsql spi sslinfo tablefunc tcn test_decoding test_parser test_shm_mq tsearch2 unaccent uuid-ossp xml2

Date/Time Configuration Files Date/Time Input Interpretation Date/Time Key Words Handling of Invalid or Ambiguous Timestamps History of Units

Acronyms PostgreSQL Error Codes SQL Key Words

clusterdb createdb createlang createuser dropdb droplang dropuser ecpg initdb pg_basebackup pg_config pg_controldata pg_ctl pg_dump pg_dumpall pg_isready pg_receivexlog pg_recvlogical pg_resetxlog pg_restore postgres postmaster psql reindexdb vacuumdb

Continuous Archiving and Point-in-Time Recovery (PITR) File System Level Backup SQL Dump

Authentication Methods Authentication Problems pg_hba.conf File User Name Maps

ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER DEFAULT PRIVILEGES ALTER DOMAIN ALTER EVENT TRIGGER ALTER EXTENSION ALTER FOREIGN DATA WRAPPER ALTER FOREIGN TABLE ALTER FUNCTION ALTER GROUP ALTER INDEX ALTER LANGUAGE ALTER LARGE OBJECT ALTER MATERIALIZED VIEW ALTER OPERATOR ALTER OPERATOR CLASS ALTER OPERATOR FAMILY ALTER ROLE ALTER RULE ALTER SCHEMA ALTER SEQUENCE ALTER SERVER ALTER SYSTEM ALTER TABLE ALTER TABLESPACE ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH TEMPLATE ALTER TRIGGER ALTER TYPE ALTER USER ALTER USER MAPPING ALTER VIEW ANALYZE BEGIN CHECKPOINT CLOSE CLUSTER COMMENT COMMIT COMMIT PREPARED COPY CREATE AGGREGATE CREATE CAST CREATE COLLATION CREATE CONVERSION CREATE DATABASE CREATE DOMAIN CREATE EVENT TRIGGER CREATE EXTENSION CREATE FOREIGN DATA WRAPPER CREATE FOREIGN TABLE CREATE FUNCTION CREATE GROUP CREATE INDEX CREATE LANGUAGE CREATE MATERIALIZED VIEW CREATE OPERATOR CREATE OPERATOR CLASS CREATE OPERATOR FAMILY CREATE ROLE CREATE RULE CREATE SCHEMA CREATE SEQUENCE CREATE SERVER CREATE TABLE CREATE TABLE AS CREATE TABLESPACE CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH TEMPLATE CREATE TRIGGER CREATE TYPE CREATE USER CREATE USER MAPPING CREATE VIEW DEALLOCATE DECLARE DELETE DISCARD DO DROP AGGREGATE DROP CAST DROP COLLATION DROP CONVERSION DROP DATABASE DROP DOMAIN DROP EVENT TRIGGER DROP EXTENSION DROP FOREIGN DATA WRAPPER DROP FOREIGN TABLE DROP FUNCTION DROP GROUP DROP INDEX DROP LANGUAGE DROP MATERIALIZED VIEW DROP OPERATOR DROP OPERATOR CLASS DROP OPERATOR FAMILY DROP OWNED DROP ROLE DROP RULE DROP SCHEMA DROP SEQUENCE DROP SERVER DROP TABLE DROP TABLESPACE DROP TEXT SEARCH CONFIGURATION DROP TEXT SEARCH DICTIONARY DROP TEXT SEARCH PARSER DROP TEXT SEARCH TEMPLATE DROP TRIGGER DROP TYPE DROP USER DROP USER MAPPING DROP VIEW END EXECUTE EXPLAIN FETCH GRANT INSERT LISTEN LOAD LOCK MOVE NOTIFY PREPARE PREPARE TRANSACTION REASSIGN OWNED REFRESH MATERIALIZED VIEW REINDEX RELEASE SAVEPOINT RESET REVOKE ROLLBACK ROLLBACK PREPARED ROLLBACK TO SAVEPOINT SAVEPOINT SECURITY LABEL SELECT SELECT ... DISTINCT SELECT ... EXCEPT SELECT ... FROM SELECT ... GROUP BY SELECT ... HAVING SELECT ... INTERSECT SELECT ... LIMIT SELECT ... ORDER BY SELECT ... UNION SELECT ... WHERE SELECT ... WINDOW SELECT ... WITH SELECT INTO SET SET CONSTRAINTS SET ROLE SET SESSION AUTHORIZATION SET TRANSACTION SHOW START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES

Caveats Concurrency Control Data Consistency Checks at the Application Level Explicit Locking Explicit Locking: Advisory Locks Explicit Locking: Deadlocks Explicit Locking: Page-level Locks Explicit Locking: Row-level Locks Explicit Locking: Table-level Locks Locking and Indexes Transaction Isolation Transaction Isolation: Read Committed Isolation Level Transaction Isolation: Repeatable Read Isolation Level Transaction Isolation: Serializable Isolation Level

Constraints Constraints: Check Constraints Constraints: Exclusion Constraints Constraints: Foreign Keys Constraints: Not-Null Constraints Constraints: Primary Keys Constraints: Unique Constraints Default Values Dependency Tracking Foreign Data Inheritance Modifying Tables Modifying Tables: Adding a Column Modifying Tables: Adding a Constraint Modifying Tables: Changing a Column's Data Type Modifying Tables: Changing a Column's Default Value Modifying Tables: Removing a Column Modifying Tables: Removing a Constraint Modifying Tables: Renaming a Column Modifying Tables: Renaming a Table Partitioning Partitioning: Alternative Partitioning Methods Partitioning: Implementing Partitioning Partitioning: Managing Partitions Partitioning: Partitioning and Constraint Exclusion Privileges