[Home] [Catalogue] [New Titles] [Articles] [News] [Site Map] [About] [Contact]

table of contents

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>>>

PostgreSQL Reference Manual
Volume 1

Buy the book here! >>>
only $49.95

Index

!

!!, factorial (prefix operator)

#

$

$

%

%, modulo (remainder)

&

‘$libdir/plugins’

*

*

*, multiplication

+

-

/

<

<<, bitwise shift left

>

>>, bitwise shift right

@

@, absolute value

^

^, exponentiation

a

Advanced features, psql

aggregate function, built-in

aggregate function, invocation

AGGREGATE, ALTER

AGGREGATE, CREATE

AGGREGATE, DROP

alias, in the FROM clause

alias, in the select list

ALTER AGGREGATE

ALTER CONVERSION

ALTER OPERATOR CLASS

ALTER TABLESPACE

Array Types, CREATE TYPE

array, constant

array, constructor

ARRAY, determination of result type

AS Key Word, SELECT

autocommit, bulk-loading data

autocommit, psql

b

backslash escapes

Base Types, CREATE TYPE

BETWEEN SYMETRIC

binary data, functions

Binary Format, COPY

binary string, concatenation

binary string, length

bit string, constant

bit string, data type

bit strings, functions

bitwise shift left

bitwise shift right

Boolean, data type

Boolean, operators

box (data type)

Building Indexes Concurrently, CREATE INDEX

c

CASCADE, foreign key action

CASCADE, with DROP

case sensitivity, of SQL commands

CASE, determination of result type

character string, concatenation

character string, constant

character string, data types

character string, length

character varying

check constraint

clock_timestamp

col_description

Column Check Constraints, CREATE TABLE

column data type, changing

column reference

column, removing

column, renaming

column, system column

Command-Line Editing, psql

comment, about database objects

comment, in SQL

COMMIT PREPARED

comparison, operators

comparison, row-wise

comparison, subquery result row

composite type, constant

composite type, constructor

Composite Types, CREATE TYPE

concatentation, of strings

conditional expression

configuration, of the server, functions

Connecting To A Database, psql

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

covariance, population

covariance, sample

CREATE AGGREGATE

CREATE CONSTRAINT

CREATE CONVERSION

CREATE DATABASE

CREATE FUNCTION

CREATE LANGUAGE

CREATE OPERATOR

CREATE OPERATOR CLASS

CREATE SEQUENCE

CREATE TABLE AS

CREATE TABLESPACE

CSV Format, COPY

current_timestamp

cursor, DECLARE

cursor, showing the query plan

d

data type, category

data type, constant

data type, conversion

data type, numeric

data type, type cast

DATABASE, ALTER

DATABASE, CREATE

date, constants

date, output format

date_part, date_part

date_trunc, date_trunc

default value, changing

DISTINCT Clause, SELECT

double precision

DROP CONVERSION

DROP OPERATOR CLASS

DROP TABLESPACE

e

Entering SQL Commands, psql

error codes, list of

escape string syntax

EXCEPT Clause, SELECT

EXPLAIN, EXPLAIN

expression, order of evaluation

expression, syntax

extract, extract

f

field selection

File Header, COPY

File Trailer, COPY

FOR UPDATE/FOR SHARE Clause, SELECT

FROM Clause, SELECT

FUNCTION, ALTER

FUNCTION, CREATE

function, in the FROM clause

function, invocation

function, type resolution in an invocation

g

generate_series

GREATEST, determination of result type

GROUP BY Clause, SELECT

h

has_database_privilege

has_function_privilege

has_language_privilege

has_schema_privilege

has_table_privilege

has_tablespace_privilege

HAVING Clause, SELECT

history, of PostgreSQL

i

identifier, length

identifier, syntax of

Index Storage Parameters, CREATE INDEX

index, building concurrently

index, combining multiple indexes

index, examining usage

index, multicolumn

index, on expressions

inet (data type)

inet_client_addr

inet_client_port

inet_server_addr

inet_server_port

Inheritance, CREATE TABLE

integer, integer

INTERSECT Clause, SELECT

interval, interval

IS DISTINCT FROM, IS DISTINCT FROM

IS NOT DISTINCT FROM, IS NOT DISTINCT FROM

j

join, controlling the order

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

LANGUAGE, ALTER

LANGUAGE, CREATE

language_handler

LEAST, determination of result type

length, of a binary string

length, of a character string

LIMIT Clause, SELECT

linear regression

m

macaddr (data type)

Meta-Commands, psql

n

name, qualified

name, syntax of

name, unqualified

Namespace Available to GROUP BY and ORDER BY, SELECT

network, data types

nonrepeatable read

Nonstandard Clauses, SELECT

not-null constraint

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

number, constant

numeric (data type)

o

obj_description

object identifier, data type

Omitted FROM Clauses, SELECT

OPERATOR CLASS, ALTER

OPERATOR CLASS, CREATE

OPERATOR CLASS, DROP

OPERATOR, ALTER

OPERATOR, CREATE

operator, invocation

operator, logical

operator, precedence

operator, syntax

operator, type resolution in an invocation

Options for Windows, pg_ctl

ORDER BY Clause, SELECT

p

parameter, syntax

path (data type)

pattern matching

patterns, in psql and pg_dump

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_conversion_is_visible

pg_current_xlog_insert_location

pg_current_xlog_location

pg_database_size

pg_function_is_visible

pg_get_constraintdef

pg_get_indexdef

pg_get_serial_sequence

pg_get_triggerdef

pg_get_userbyid

pg_is_other_temp_schema

pg_my_temp_schema

pg_opclass_is_visible

pg_operator_is_visible

pg_postmaster_start_time

pg_relation_size

pg_rotate_logfile

pg_start_backup

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

pi, mathematical constant

precedence, operator

predicate locking

PREPARE TRANSACTION

prepared statements, creating

prepared statements, executing

prepared statements, removing

prepared statements, showing the query plan

privilege, for schemas

privilege, querying

Prompting, psql

q

quotation marks, and identifiers

quotation marks, escaping

r

referential integrity

regression intercept

regression slope

regular expression, regular expression

RELEASE SAVEPOINT

Restarting the Server, pg_ctl

RESTRICT, foreign key action

RESTRICT, with DROP

ROLLBACK PREPARED

ROLLBACK TO SAVEPOINT

row type, constructor

row-wise comparison

s

SAVEPOINT, RELEASE

savepoints, defining

savepoints, releasing

savepoints, rolling back

schema, creating

schema, current, schema, current

schema, removing

search path, current

SELECT List, SELECT

SELECT, select list

SEQUENCE, ALTER

sequence, and serial type

SEQUENCE, CREATE

serializability

Server Status, pg_ctl

SESSION AUTHORIZATION, SET

SET CONSTRAINTS

set intersection

set returning functions, functions

SET SESSION AUTHORIZATION

SET TRANSACTION

shobj_description

signal, backend processes

SOME, SOME, SOME

SQL Interpolation, psql

standard deviation

standard deviation, population

standard deviation, sample

START TRANSACTION

Starting the Server, pg_ctl

statement_timestamp

statistics, of the planner

Stopping the Server, pg_ctl

Storage Parameters, CREATE TABLE

subquery, subquery, subquery

substring, substring, substring

system catalog, schema

t

TABLE AS, CREATE

table expression

table, creating

table, inheritance

table, modifying

table, partitioning

table, removing

table, renaming

TABLESPACE, ALTER

TABLESPACE, CREATE

TABLESPACE, DROP

Tablespaces, CREATE TABLE

Temporary Tables, CREATE TABLE

Text Format, COPY

time with time zone, time with time zone

time without time zone, time without time zone

time zone, conversion

time zone, input abbreviations

time, constants

time, output format

timestamp, timestamp

timestamp with time zone, timestamp with time zone

timestamp without time zone, timestamp without time zone

TOAST, per-column storage settings

transaction isolation

transaction isolation level

transaction isolation level, read committed

transaction isolation level, serializable

TRANSACTION, PREPARE

TRANSACTION, SET

TRANSACTION, START

transaction_timestamp

TRIGGER, CREATE

two-phase commit, two-phase commit, two-phase commit

type cast, type cast

u

UNION Clause, SELECT

UNION, determination of result type

unique constraint

unqualified name

v

value expression

VALUES, determination of result type

Variables, psql

variance, population

variance, sample

w

WHERE Clause, SELECT

WITH clause, CREATE TABLE

x

z

Zero-column tables, CREATE TABLE

|

|/, square root

||, string concatentation

~

table of contents

ISBN 0954612027

PostgreSQL Reference Manual - Volume 1 - SQL Language Reference

See the print edition