Credit to devdocs.io
Back
Forward
Menu
Home
Clear search
postgresql 9.4
API Mirror
9.4
postgresql
44
Appendix: Additional Supplied Modules
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
5
Appendix: Date/Time Support
Date/Time Configuration Files
Date/Time Input Interpretation
Date/Time Key Words
Handling of Invalid or Ambiguous Timestamps
History of Units
3
Appendixes
Acronyms
PostgreSQL Error Codes
SQL Key Words
25
Applications
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
3
Backup and Restore
Continuous Archiving and Point-in-Time Recovery (PITR)
File System Level Backup
SQL Dump
4
Client Authentication
Authentication Methods
Authentication Problems
pg_hba.conf File
User Name Maps
171
Commands
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
14
Concurrency Control
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
34
Data Definition
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
Schemas
Schemas: Creating a Schema
Schemas: Public Schema
Schemas: Schema Search Path
Schemas: Schemas and Privileges
Schemas: System Catalog Schema