postgresql 9.6

adminpack auth_delay auto_explain bloom btree_gin btree_gist chkpass citext cube dict_int dict_xsyn 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 pg_visibility postgres_fdw seg sepgsql spi sslinfo tablefunc tcn test_decoding tsearch2 tsm_system_rows tsm_system_time 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 pgbench pg_archivecleanup pg_basebackup pg_config pg_controldata pg_ctl pg_dump pg_dumpall pg_isready pg_receivexlog pg_recvlogical pg_resetxlog pg_restore pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_xlogdump 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 POLICY 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 ACCESS METHOD 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 POLICY 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 TRANSFORM CREATE TRIGGER CREATE TYPE CREATE USER CREATE USER MAPPING CREATE VIEW DEALLOCATE DECLARE DELETE DISCARD DO DROP ACCESS METHOD 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 POLICY 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 TRANSFORM DROP TRIGGER DROP TYPE DROP USER DROP USER MAPPING DROP VIEW END EXECUTE EXPLAIN FETCH GRANT IMPORT FOREIGN SCHEMA INSERT INSERT ... ON CONFLICT 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