- publishing free software manuals
PostgreSQL Reference Manual - Volume 1 - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
ISBN 0954612027
RRP £32.00 ($49.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

Index

!

  • !!, factorial (prefix operator)
  • !, factorial
  • #

  • #, bitwise XOR
  • $

  • $
  • %

  • %, modulo (remainder)
  • &

  • &, bitwise AND
  • ‘$libdir/plugins’
  • *

  • *
  • *, multiplication
  • +

  • +, addition
  • -

  • -, subtraction
  • /

  • /, division
  • <

  • <<, bitwise shift left
  • >

  • >>, bitwise shift right
  • @

  • @, absolute value
  • ^

  • ^, exponentiation
  • a

  • ABORT
  • abs
  • absolute value
  • acos
  • Advanced features, psql
  • age
  • aggregate function, built-in
  • aggregate function, invocation
  • AGGREGATE, ALTER
  • AGGREGATE, CREATE
  • AGGREGATE, DROP
  • alias, in the FROM clause
  • alias, in the select list
  • ALL, ALL
  • ALTER AGGREGATE
  • ALTER CONVERSION
  • ALTER DATABASE
  • ALTER DOMAIN
  • ALTER FUNCTION
  • ALTER GROUP
  • ALTER INDEX
  • ALTER LANGUAGE
  • ALTER OPERATOR
  • ALTER OPERATOR CLASS
  • ALTER ROLE
  • ALTER SCHEMA
  • ALTER SEQUENCE
  • ALTER TABLE
  • ALTER TABLESPACE
  • ALTER TRIGGER
  • ALTER TYPE
  • ALTER USER
  • ANALYZE
  • AND (operator)
  • AND, bitwise
  • ANY, ANY, ANY
  • any
  • anyarray
  • anyelement
  • area
  • ARRAY
  • array
  • Array Types, CREATE TYPE
  • array, constant
  • array, constructor
  • ARRAY, determination of result type
  • AS Key Word, SELECT
  • ascii
  • asin
  • AT TIME ZONE
  • atan
  • atan2
  • auto-increment
  • autocommit, bulk-loading data
  • autocommit, psql
  • average
  • b

  • B-tree
  • backslash escapes
  • backup
  • Base Types, CREATE TYPE
  • BEGIN
  • BETWEEN
  • BETWEEN SYMETRIC
  • bigint, bigint
  • bigserial
  • binary data
  • binary data, functions
  • Binary Format, COPY
  • binary string, concatenation
  • binary string, length
  • bit string, constant
  • bit string, data type
  • bit strings, functions
  • bit_and
  • bit_length
  • bit_or
  • bitmap scan
  • bitwise AND
  • bitwise NOT
  • bitwise OR
  • bitwise shift left
  • bitwise shift right
  • bitwise XOR
  • bool_and
  • bool_or
  • Boolean, data type
  • Boolean, operators
  • box (data type)
  • btrim
  • Building Indexes Concurrently, CREATE INDEX
  • bytea
  • c

  • CASCADE, foreign key action
  • CASCADE, with DROP
  • CASE
  • case sensitivity, of SQL commands
  • CASE, determination of result type
  • CAST, CREATE
  • CAST, DROP
  • cbrt
  • ceiling
  • center
  • char
  • char_length
  • character
  • character string, concatenation
  • character string, constant
  • character string, data types
  • character string, length
  • character varying
  • check constraint
  • CHECKPOINT
  • chr
  • cid
  • cidr
  • circle
  • clock_timestamp
  • CLOSE
  • CLUSTER
  • clusterdb
  • cmax
  • cmin
  • COALESCE
  • col_description
  • column
  • Column Check Constraints, CREATE TABLE
  • column data type, changing
  • column reference
  • column, adding
  • column, removing
  • column, renaming
  • column, system column
  • Command-Line Editing, psql
  • COMMENT
  • comment, about database objects
  • comment, in SQL
  • COMMIT
  • COMMIT PREPARED
  • comparison, operators
  • comparison, row-wise
  • comparison, subquery result row
  • composite type
  • composite type, constant
  • composite type, constructor
  • Composite Types, CREATE TYPE
  • concatentation, of strings
  • concurrency
  • conditional expression
  • configuration, of the server, functions
  • conjunction
  • Connecting To A Database, psql
  • constant
  • constraint
  • constraint exclusion
  • constraint, adding
  • constraint, check
  • CONSTRAINT, CREATE
  • constraint, foreign key
  • constraint, name
  • constraint, NOT NULL
  • constraint, primary key
  • constraint, removing
  • constraint, unique
  • CONSTRAINTS, SET
  • CONVERSION, ALTER
  • CONVERSION, CREATE
  • CONVERSION, DROP
  • convert
  • COPY
  • correlation
  • cos
  • cot
  • covariance, population
  • covariance, sample
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE CONSTRAINT
  • CREATE CONVERSION
  • CREATE DATABASE
  • CREATE DOMAIN
  • CREATE FUNCTION
  • CREATE GROUP
  • CREATE INDEX
  • CREATE LANGUAGE
  • CREATE OPERATOR
  • CREATE OPERATOR CLASS
  • CREATE ROLE
  • CREATE RULE
  • CREATE SCHEMA
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TABLESPACE
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE USER
  • CREATE VIEW
  • createdb
  • createlang
  • createuser
  • cross join
  • cstring
  • CSV Format, COPY
  • ctid
  • cube root
  • current_date
  • current_time
  • current_timestamp
  • currval
  • cursor, CLOSE
  • cursor, DECLARE
  • cursor, FETCH
  • cursor, MOVE
  • cursor, showing the query plan
  • d

  • data type
  • data type, category
  • data type, constant
  • data type, conversion
  • data type, numeric
  • data type, type cast
  • DATABASE, ALTER
  • DATABASE, CREATE
  • DATABASE, DROP
  • date, date
  • date, constants
  • date, current
  • date, output format
  • date_part, date_part
  • date_trunc, date_trunc
  • deadlock
  • DEALLOCATE
  • decimal
  • DECLARE
  • decode
  • default value
  • default value, changing
  • degrees
  • delay
  • DELETE, DELETE
  • deleting
  • diameter
  • dirty read
  • disjunction
  • DISTINCT
  • DISTINCT Clause, SELECT
  • dollar quoting
  • DOMAIN, ALTER
  • DOMAIN, CREATE
  • DOMAIN, DROP
  • double precision
  • DROP AGGREGATE
  • DROP CAST
  • DROP CONVERSION
  • DROP DATABASE
  • DROP DOMAIN
  • DROP FUNCTION
  • DROP GROUP
  • DROP INDEX
  • DROP LANGUAGE
  • DROP OPERATOR
  • DROP OPERATOR CLASS
  • DROP OWNED
  • DROP ROLE
  • DROP RULE
  • DROP SCHEMA
  • DROP SEQUENCE
  • DROP TABLE
  • DROP TABLESPACE
  • DROP TRIGGER
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • dropdb
  • droplang
  • dropuser
  • duplicates
  • e

  • ecpg
  • encode
  • END
  • Entering SQL Commands, psql
  • error codes, list of
  • escape string syntax
  • every
  • EXCEPT
  • EXCEPT Clause, SELECT
  • exclusive OR
  • EXECUTE
  • EXISTS
  • exp
  • EXPLAIN, EXPLAIN
  • exponentiation
  • expression, order of evaluation
  • expression, syntax
  • extract, extract
  • f

  • factorial
  • false
  • FETCH
  • field selection
  • File Header, COPY
  • File Trailer, COPY
  • float4
  • float8
  • floating point
  • floor
  • FOR UPDATE/FOR SHARE Clause, SELECT
  • foreign key
  • format_type
  • formatting
  • FROM Clause, SELECT
  • function
  • FUNCTION, ALTER
  • FUNCTION, CREATE
  • FUNCTION, DROP
  • function, in the FROM clause
  • function, invocation
  • function, type resolution in an invocation
  • g

  • generate_series
  • get_bit
  • get_byte
  • GIN
  • GiST
  • GRANT
  • GREATEST
  • GREATEST, determination of result type
  • GROUP BY
  • GROUP BY Clause, SELECT
  • GROUP, ALTER
  • GROUP, CREATE
  • GROUP, DROP
  • grouping
  • h

  • has_database_privilege
  • has_function_privilege
  • has_language_privilege
  • has_schema_privilege
  • has_table_privilege
  • has_tablespace_privilege
  • hash
  • HAVING
  • HAVING Clause, SELECT
  • height
  • history, of PostgreSQL
  • i

  • identifier, length
  • identifier, syntax of
  • IFNULL
  • IN, IN
  • index
  • Index
  • Index Storage Parameters, CREATE INDEX
  • INDEX, ALTER
  • index, B-tree
  • index, building concurrently
  • index, combining multiple indexes
  • INDEX, CREATE
  • INDEX, DROP
  • index, examining usage
  • index, GIN
  • index, GiST
  • index, hash
  • index, locks
  • index, multicolumn
  • index, on expressions
  • index, partial
  • index, unique
  • inet (data type)
  • inet_client_addr
  • inet_client_port
  • inet_server_addr
  • inet_server_port
  • inheritance
  • Inheritance, CREATE TABLE
  • initcap
  • initdb
  • INSERT, INSERT
  • inserting
  • int2
  • int4
  • int8
  • integer, integer
  • internal
  • INTERSECT
  • INTERSECT Clause, SELECT
  • interval, interval
  • INTO, SELECT
  • ipcclean
  • IS DISTINCT FROM, IS DISTINCT FROM
  • IS FALSE
  • IS NOT DISTINCT FROM, IS NOT DISTINCT FROM
  • IS NOT FALSE
  • IS NOT NULL
  • IS NOT TRUE
  • IS NOT UNKNOWN
  • IS NULL
  • IS TRUE
  • IS UNKNOWN
  • isclosed
  • isfinite
  • ISNULL
  • isopen
  • j

  • join
  • join, controlling the order
  • join, cross
  • join, left
  • join, natural
  • join, outer
  • join, right
  • justify_days
  • justify_hours
  • justify_interval
  • k

  • key word, list of
  • key word, syntax of
  • key, foreign, key, foreign
  • key, primary, key, primary
  • Killing the Server, pg_ctl
  • l

  • label
  • LANGUAGE, ALTER
  • LANGUAGE, CREATE
  • LANGUAGE, DROP
  • language_handler
  • lastval
  • LEAST
  • LEAST, determination of result type
  • left join
  • left shift
  • length
  • length, of a binary string
  • length, of a character string
  • LIKE
  • LIMIT
  • LIMIT Clause, SELECT
  • line segment
  • linear regression
  • LISTEN
  • ln
  • LOAD
  • localtime
  • localtimestamp
  • LOCK, LOCK
  • lock
  • lock, advisory
  • log
  • lower
  • lpad
  • lseg
  • ltrim
  • m

  • MAC address
  • macaddr (data type)
  • md5
  • Meta-Commands, psql
  • mod
  • modulo
  • MOVE
  • MVCC
  • n

  • name, qualified
  • name, syntax of
  • name, unqualified
  • Namespace Available to GROUP BY and ORDER BY, SELECT
  • natural join
  • negation
  • network, data types
  • nextval
  • nonrepeatable read
  • Nonstandard Clauses, SELECT
  • NOT (operator)
  • NOT IN, NOT IN
  • NOT, bitwise
  • not-null constraint
  • NOTIFY
  • NOTNULL
  • now
  • npoints
  • NULL Constraint, CREATE TABLE
  • null value, comparing
  • null value, default value
  • null value, in DISTINCT
  • null value, with check constraints
  • null value, with unique constraints
  • NULLIF
  • number, constant
  • numeric
  • numeric (data type)
  • NVL
  • o

  • obj_description
  • object identifier, data type
  • octet_length
  • OFFSET
  • oid
  • OID, column
  • Omitted FROM Clauses, SELECT
  • ONLY
  • opaque
  • operator
  • operator class
  • OPERATOR CLASS, ALTER
  • OPERATOR CLASS, CREATE
  • OPERATOR CLASS, DROP
  • OPERATOR, ALTER
  • OPERATOR, CREATE
  • OPERATOR, DROP
  • operator, invocation
  • operator, logical
  • operator, precedence
  • operator, syntax
  • operator, type resolution in an invocation
  • Options for Windows, pg_ctl
  • OR (operator)
  • OR, bitwise
  • ORDER BY
  • ORDER BY Clause, SELECT
  • outer join
  • overlay
  • OWNED, DROP
  • p

  • parameter, syntax
  • parenthesis
  • partitioning
  • path (data type)
  • pattern matching
  • patterns, in psql and pg_dump
  • Patterns, psql
  • pclose
  • performance
  • permission
  • pg_advisory_lock
  • pg_advisory_lock_shared
  • pg_advisory_unlock
  • pg_advisory_unlock_all
  • pg_advisory_unlock_shared
  • pg_cancel_backend
  • pg_client_encoding
  • pg_column_size
  • pg_config
  • pg_controldata
  • pg_conversion_is_visible
  • pg_ctl
  • pg_current_xlog_insert_location
  • pg_current_xlog_location
  • pg_database_size
  • pg_dump
  • pg_dumpall
  • pg_function_is_visible
  • pg_get_constraintdef
  • pg_get_expr
  • pg_get_indexdef
  • pg_get_ruledef
  • pg_get_serial_sequence
  • pg_get_triggerdef
  • pg_get_userbyid
  • pg_get_viewdef
  • pg_has_role
  • pg_is_other_temp_schema
  • pg_ls_dir
  • pg_my_temp_schema
  • pg_opclass_is_visible
  • pg_operator_is_visible
  • pg_postmaster_start_time
  • pg_read_file
  • pg_relation_size
  • pg_reload_conf
  • pg_restore
  • pg_rotate_logfile
  • pg_size_pretty
  • pg_sleep
  • pg_start_backup
  • pg_stat_file
  • pg_statistic
  • pg_stats
  • pg_stop_backup
  • pg_switch_xlog
  • pg_table_is_visible
  • pg_tablespace_databases
  • pg_tablespace_size
  • pg_total_relation_size
  • pg_try_advisory_lock
  • pg_try_advisory_lock_shared
  • pg_type_is_visible
  • pg_xlogfile_name
  • pg_xlogfile_name_offset
  • phantom read
  • pi, mathematical constant
  • point
  • polygon
  • popen
  • position
  • postgres
  • POSTGRES
  • Postgres95
  • postmaster
  • power
  • precedence, operator
  • predicate locking
  • PREPARE
  • PREPARE TRANSACTION
  • prepared statements, creating
  • prepared statements, executing
  • prepared statements, removing
  • prepared statements, showing the query plan
  • primary key
  • privilege
  • privilege, for schemas
  • privilege, querying
  • Prompting, psql
  • psql
  • q

  • qualified name
  • query
  • query plan
  • quotation marks, and identifiers
  • quotation marks, escaping
  • quote_ident
  • quote_literal
  • r

  • radians
  • radius
  • random
  • real
  • REASSIGN OWNED
  • record
  • rectangle
  • referential integrity
  • regclass
  • regexp_replace
  • regoper
  • regoperator
  • regproc
  • regprocedure
  • regression intercept
  • regression slope
  • regtype
  • regular expression, regular expression
  • REINDEX
  • reindexdb
  • RELEASE SAVEPOINT
  • remainder
  • repeat
  • replace
  • RESET
  • Restarting the Server, pg_ctl
  • RESTRICT, foreign key action
  • RESTRICT, with DROP
  • REVOKE
  • right join
  • right shift
  • ROLE, ALTER
  • ROLE, CREATE
  • ROLE, DROP
  • ROLE, SET
  • ROLLBACK
  • ROLLBACK PREPARED
  • ROLLBACK TO SAVEPOINT
  • rollback, psql
  • round
  • ROW
  • row
  • row type
  • row type, constructor
  • row-wise comparison
  • rpad
  • rtrim
  • RULE, CREATE
  • RULE, DROP
  • s

  • SAVEPOINT
  • SAVEPOINT, RELEASE
  • savepoints, defining
  • savepoints, releasing
  • savepoints, rolling back
  • scalar
  • schema
  • SCHEMA, ALTER
  • SCHEMA, CREATE
  • schema, creating
  • schema, current, schema, current
  • SCHEMA, DROP
  • schema, public
  • schema, removing
  • search path
  • search path, current
  • search_path
  • SELECT, SELECT
  • SELECT INTO
  • SELECT List, SELECT
  • SELECT, select list
  • sequence
  • SEQUENCE, ALTER
  • sequence, and serial type
  • SEQUENCE, CREATE
  • SEQUENCE, DROP
  • serial
  • serial4
  • serial8
  • serializability
  • Server Status, pg_ctl
  • SESSION AUTHORIZATION, SET
  • SET, SET
  • SET CONSTRAINTS
  • set difference
  • set intersection
  • set operation
  • set returning functions, functions
  • SET ROLE
  • SET SESSION AUTHORIZATION
  • SET TRANSACTION
  • set union
  • set_bit
  • set_byte
  • setseed
  • setval
  • shift left
  • shift right
  • shobj_description
  • SHOW, SHOW
  • sign
  • signal, backend processes
  • SIMILAR TO
  • sin
  • sleep
  • smallint
  • SOME, SOME, SOME
  • sorting
  • split_part
  • SQL Interpolation, psql
  • sqrt
  • square root
  • standard deviation
  • standard deviation, population
  • standard deviation, sample
  • START TRANSACTION
  • Starting the Server, pg_ctl
  • statement_timestamp
  • statistics
  • statistics, of the planner
  • Stopping the Server, pg_ctl
  • Storage Parameters, CREATE TABLE
  • string
  • strpos
  • subquery, subquery, subquery
  • subscript
  • substr
  • substring, substring, substring
  • syntax, SQL
  • system catalog, schema
  • t

  • table
  • TABLE AS, CREATE
  • table expression
  • table function
  • TABLE, ALTER
  • TABLE, CREATE
  • table, creating
  • TABLE, DROP
  • table, inheritance
  • table, modifying
  • table, partitioning
  • table, removing
  • table, renaming
  • tableoid
  • TABLESPACE, ALTER
  • TABLESPACE, CREATE
  • TABLESPACE, DROP
  • Tablespaces, CREATE TABLE
  • tan
  • Temporary Tables, CREATE TABLE
  • text
  • Text Format, COPY
  • tid
  • time, time
  • time span
  • time with time zone, time with time zone
  • time without time zone, time without time zone
  • time zone
  • time zone, conversion
  • time zone, input abbreviations
  • time, constants
  • time, current
  • time, output format
  • timeofday
  • timestamp, timestamp
  • timestamp with time zone, timestamp with time zone
  • timestamp without time zone, timestamp without time zone
  • to_ascii
  • to_char
  • to_date
  • to_hex
  • to_number
  • to_timestamp
  • TOAST, per-column storage settings
  • token
  • transaction isolation
  • transaction isolation level
  • transaction isolation level, read committed
  • transaction isolation level, serializable
  • TRANSACTION, PREPARE
  • TRANSACTION, SET
  • TRANSACTION, START
  • transaction_timestamp
  • translate
  • trigger
  • TRIGGER, ALTER
  • TRIGGER, CREATE
  • TRIGGER, DROP
  • trim
  • true
  • trunc
  • TRUNCATE
  • Tuples, COPY
  • two-phase commit, two-phase commit, two-phase commit
  • type
  • type cast, type cast
  • TYPE, ALTER
  • TYPE, CREATE
  • TYPE, DROP
  • u

  • UNION
  • UNION Clause, SELECT
  • UNION, determination of result type
  • unique constraint
  • UNLISTEN
  • unqualified name
  • UPDATE, UPDATE
  • updating
  • upper
  • USER, ALTER
  • USER, CREATE
  • user, current
  • USER, DROP
  • v

  • VACUUM
  • vacuumdb
  • value expression
  • VALUES, VALUES
  • VALUES, determination of result type
  • varchar
  • Variables, psql
  • variance
  • variance, population
  • variance, sample
  • version
  • VIEW, CREATE
  • VIEW, DROP
  • void
  • w

  • WHERE
  • WHERE Clause, SELECT
  • width
  • width_bucket
  • WITH clause, CREATE TABLE
  • x

  • xid
  • xmax
  • xmin
  • xml
  • XOR
  • z

  • Zero-column tables, CREATE TABLE
  • |

  • |, bitwise OR
  • |/, square root
  • ||, string concatentation
  • ||/, cube root
  • ~

  • ~, bitwise NOT

  • ISBN 0954612027PostgreSQL Reference Manual - Volume 1 - SQL Language ReferenceSee the print edition