Index

Assignment to Program Variables

access control

table permissions: see table, permissions

administration

no title | Administration to Summary

access: no title | Access Configuration to Examples | no title | 3.6) How do I POSTGRESQL to 3.7) Why can't I | no title | pg_passwd to Description | no title | pg_upgrade to Upgrading Postgres with pg_upgrade
backup: Not Backed Up by | Not Backed Up by to Not Backed Up by | Using COPY | no title | Backup and Restore to Backup and Restore | no title | pg_dump to Usage
database: no title | Creating Databases to Creating Databases | no title | CREATE DATABASE to SQL92 | no title | createdb to Usage | no title | DROP DATABASE to SQL92 | no title | dropdb to Usage
debugging: no title | 3.11) What debugging features to 3.11) What debugging features | no title to 4.19) Why do I ``FATAL:
disk space: no title | 4.7) How much database to 4.7) How much database
files: no title | Files to Files
initialization: no title | initdb to Description
installation: no title | Installation to Creating a Database
monitoring: no title | Monitoring to Monitoring
performance: no title | Performance to Summary | no title | Performance to Performance | no title | 3.10) How do I to 3.10) How do I | no title to 4.10) How do I | no title | 4.12) What is Genetic to 4.12) What is Genetic | no title | 4.23) Why are my IN to 4.23) Why are my IN | no title to SQL92
restore: no title | Backup and Restore to Backup and Restore | no title | pg_dump to Usage
server: no title | Server Start-up and Shutdown to Monitoring | no title | 3.3)When I start the postmaster, Bad Call to 3.5) When I try postmaster, IpcSemaphoreCreate | 3.10) How do I to 3.10) How do I | no title | 3.12) I get ``Sorry, clients'' to 3.13) What are the pg_sorttempNNN.NN | no title | 4.6) What is the to 4.6) What is the | no title | pg_ctl to postmaster status | no title | postgres to Usage
server version: no title | 4.20) How do I POSTGRESQL to 4.20) How do I POSTGRESQL
system tables: see system tables
upgrade: no title | Upgrading to Upgrading
user: see user

aggregate

no title | SQL Aggregates to Summary | Three- and Four-Table Joins

distinct: Aggregates
functions: see avg, count, max, min, sum
group by: see select, group by
having: see select, having
listing: Listing Commands

alias

see table, alias

alter table

see table, alter

alter user

see user, alter

analyze

see vacuum, analyze

and

no title | AND/OR Usage to AND/OR Usage

array

no title | Arrays to Arrays | PostgreSQL Nonstandard Features by

Ascii export/import

see copy

atoi()

attribute not found

Viewing Data with SELECT

autonumbering

see sequence

average

see avg

avg

backend

see administration, server

backup

see administration, backup

begin work

no title | Multistatement Transactions to Multistatement Transactions | no title | BEGIN to SQL92

between

no title | Range of Values to Range of Values

blob

see large object

bool

Installed Types

boolean

Logical | Support Operators | PL/PGSQL Functions

box

bpchar()

4.15) What is the

broadcast()

bytea

4.15) What is the | 4.15) What is the

C++

see libpq++

Cartesian product

Unjoined Tables

case

no title | CASE Clause to CASE Clause | SQL Functions | SQL Functions

cast

no title to Type Conversion Using CAST | Support Functions to Support Functions | Support Operators to Support Operators | SQL Functions to SQL Functions

cbrt()

Cgi

Perl | 2.2) What tools are POSTGRESQL

char()

character_length()

check

no title to CHECK | Triggers | Triggers

Chen, Jolly

Foreword to Foreword | University of California at | University of California at | Development Leaves Berkeley | 1.1) What is POSTGRESQL?

cidr

Installed Types | Network to Network

circle

Starting a Database Session

client/server

close

no title | Cursors to Cursors | no title | CLOSE to SQL92

cluster

no title to CLUSTER | PostgreSQL Nonstandard Features by | no title to SQL92

coalesce()

column label

see select, column label

column name, with table prefix

no title | Table and Column References to Table and Column References | Performing Joins to Performing Joins

comment

no title | Comments to Comments | Listing Commands | no title | COMMENT to SQL92

listing: Listing Commands

commercial support

Commercial Support

commit work

no title | Multistatement Transactions to Multistatement Transactions | no title | COMMIT to SQL92

compiler

see programming, compiling

constraint

no title | Constraints to Summary

check

no title to CHECK

foreign key

no title | Primary and Foreign Keys to Primary and Foreign Keys | no title to Frequency of Foreign Key

action: Modification of Primary Key to Modification of Primary Key
checking frequency: no title | Frequency of Foreign Key to Frequency of Foreign Key
defer: no title | Frequency of Foreign Key to Frequency of Foreign Key

not null

no title to NOT NULL

primary key

no title | Primary and Foreign Keys to Primary and Foreign Keys | no title to PRIMARY KEY

multicolumn: no title | Multicolumn Foreign Keys to Multicolumn Foreign Keys
with foreign key: no title to Handling NULL Values in

referential integrity

no title to Frequency of Foreign Key

unique

no title to UNIQUE

copy

backslash: no title | Backslashes and NULL Values to Backslashes and NULL Values
delimiters: no title to DELIMITERS
file format: no title | COPY File Format to COPY File Format
null: no title | Backslashes and NULL Values to Backslashes and NULL Values
stdin/stdout: no title | COPY Without Files to COPY Without Files

correlated subquery

see subquery, correlated

count

create aggregate

Extending POSTGRESQL Using C | Create Operators, Types, and | no title | CREATE AGGREGATE to SQL92

create database

see database

create function

see function

create group

Creating Users | no title | CREATE GROUP to SQL92

create index

see index

create operator

see operator, creation

create rule

see rule

create table

see table, creation

create trigger

see trigger

create type

Extending POSTGRESQL Using C | Create Operators, Types, and | no title | CREATE TYPE to SQL3

create user

see user

create view

see view

createdb

see database, creation

createlang

PL/PGSQL Functions | no title | createlang to Usage

createuser

see user

crypt

Local | User Mappings | User Mappings | Examples

currval()

Creating Sequences to Creating Sequences

cursor

binary: Assignment to Program Variables to Assignment to Program Variables | Description to Description

data type

date display: SET, SHOW, and RESET to SET, SHOW, and RESET
installed: no title | Installed Types to Internal
listing: Listing Commands
serial: no title | Serial Column Type to Serial Column Type | no title | 4.16.1) How do I to 4.16.3) Don't currval() and nextval()
use of: no title | Data Types to Purpose of Data Types

database

creation: no title | Creating a Database to Creating a Database | no title | CREATE DATABASE to SQL92
destruction: no title | dropdb to Usage
listing: Listing Commands
server: see administration, server
server version: see administration, server version
use of: Introduction to Introduction

date

Data Types | Installed Types | Temporal to Temporal | Type Conversion Using CAST

date, current

Support Variables

date_part()

Support Functions | Support Functions | Functions and Triggers

date_trunc()

UNION, EXCEPT, and INTERSECT to UNION, EXCEPT, and INTERSECT | UNION, EXCEPT, and INTERSECT

deadlock

no title | Deadlocks to Deadlocks

debugging

see administration, debugging

decimal

see numeric

declare

no title | Cursors to Cursors | Assignment to Program Variables | no title | DECLARE to SQL92

pl/pgsql: PL/PGSQL Functions

default

foreign key: Modification of Primary Key

delete

foreign key: Modification of Primary Key | Modification of Primary Key | Modification of Primary Key | Frequency of Foreign Key
grant: GRANT and REVOKE
on view: Views
rule: no title | Rules | Rules
subquery: Subqueries in Non-SELECT Queries
trigger: Triggers

delimiters

COPY File Format | no title to DELIMITERS

distinct

no title | Distinct Rows to Distinct Rows | Three- and Four-Table Joins

aggregate: Aggregates

do instead

see rule

drop database

see database

drop function

see function

drop index

see index

drop rule

see rule

drop table

see table, destruction

drop trigger

see trigger

drop user

see user

drop view

see view

dropdb

see database

dynamic linking

Compile the C Code

ecpg

embedded Sql

see ecpg

equijoin

see join, equi

except

exp()

explain

no title to EXPLAIN | PostgreSQL Nonstandard Features by | no title | EXPLAIN to SQL92

export

see copy

extract()

factorial()

Assignment to Program Variables

false

see boolean

fetch

no title | Cursors to Cursors | no title | FETCH to SQL92

fetch()

float

Data Types | Installed Types to Number | Number | Assignment to Program Variables | Assignment to Program Variables to Assignment to Program Variables

float4

Installed Types | Number to Number

foreign key

see constraint, foreign key | see constraint, foreign key

function

listing: Listing Commands
pl/pgsql: no title | PL/PGSQL Functions to PL/PGSQL Functions
server-side: no title | Functions to Summary | PostgreSQL Nonstandard Features by
sql: no title | SQL Functions to SQL Functions
trigger: no title | Triggers to Triggers | PostgreSQL Nonstandard Features by

grant

grep

Regular Expressions

group by

see select, group by

hash join

see join, hash

having

see select, having

host

no title | Host and Hostssl to Host and Hostssl

host()

University of California at

hostssl

no title | Host and Hostssl to Host and Hostssl

Html

Programming Interfaces | no title to PHP

ident

Host and Hostssl | User Mappings | User Mappings

Illustra

import

see copy

include file

Compiling Programs | Files

index

listing: Listing Commands | Listing Commands
unique: no title | Unique Indexes to Unique Indexes | no title to UNIQUE

index scan

EXPLAIN

inet

Installed Types | Network to Network

Informix

University of California at

Ingres

University of California at

inheritance

no title | Inheritance to Inheritance

initcap()

UNION, EXCEPT, and INTERSECT to UNION, EXCEPT, and INTERSECT | UNION, EXCEPT, and INTERSECT

initdb

initialization

see administration, initialization

initlocation

Performance | no title | initlocation to Usage

insert

and null: no title | Using NULL Values to Using NULL Values
and select: no title to Inserting Data Using SELECT
default: no title | Controlling DEFAULT Values to Controlling DEFAULT Values
on view: Views
rule: no title | Rules | Rules
trigger: no title | Triggers | Triggers | Triggers
update: no title | Triggers | Triggers

installation

see administration, installation

instead

Rules

int2

Installed Types | Number to Number

int8

Installed Types | Number to Number

integer

interfaces

see ecpg, jdbc, libpgeasy, libpq, libpq++, Odbc, Perl, Php, Python

internationalization

no title | Internationalization to Internationalization

intersect

interval

Installed Types | Temporal to Temporal

isfinite()

Server Start-up and Shutdown

isolation level

see read committed and serializable

jar

Java (JDBC)

Java

see jdbc

javac

Java (JDBC)

jdbc

Programming Interfaces | no title to Java (JDBC) | 2.4) What languages are POSTGRESQL? | PostgreSQL Nonstandard Features by

join

no title | Joining Tables to Summary | Subqueries as Constants

anti: Subqueries as Lists of
eliminating: Subqueries as Constants
equijoin: Non-equijoins
hash: EXPLAIN
key: no title | Choosing a Join Key to Choosing a Join Key | Object Identification Numbers (OIDs) | Object Identification Numbers (OIDs)
manual: Performing Joins
merge: EXPLAIN
nested loop: EXPLAIN
non-equijoin: no title | Non-equijoins to Non-equijoins
one-to-many: no title | One-to-Many Joins to One-to-Many Joins
outer: One-to-Many Joins | no title | Outer Joins to Outer Joins | no title | 4.24) How do I to 4.24) How do I
self: no title | Table Aliases and Self-joins to Table Aliases and Self-joins | Subqueries as Constants
types: EXPLAIN | EXPLAIN
unjoined: no title | Unjoined Tables to Unjoined Tables
using multiple tables: no title | Joined Tables to Joined Tables
view: Views

Kerberos

Host and Hostssl

key

see join, key

kill

krb

Host and Hostssl | Host and Hostssl

large object

no title | Large Objects (BLOBs) to Large Objects (BLOBs) | no title | 4.21) My large-object operations invalid descriptor. to 4.21) My large-object operations invalid descriptor. | PostgreSQL Nonstandard Features by

listing: Listing Commands
psql: no title | Large Object Commands to Large Object Commands

length()

Support Functions | CHECK

libpgeasy

Programming Interfaces | no title to Pgeasy (LIBPGEASY) | Compiling Programs | Assignment to Program Variables | 2.4) What languages are POSTGRESQL?

libpq

functions: C Language Interface (LIBPQ) to C Language Interface (LIBPQ)

libpq++

Programming Interfaces | no title to C++ (LIBPQ++) | 2.4) What languages are POSTGRESQL?

library file

Compiling Programs | Files

like

see where, like | see where, like

limit

no title to LIMIT | no title | 4.3) How do I SELECT to 4.3) How do I SELECT | PostgreSQL Nonstandard Features by

Linux

POSTGRESQL Global Development Team

listen

ln()

lo_export()

Large Objects (BLOBs) to Large Objects (BLOBs)

lo_import()

Large Objects (BLOBs) to Large Objects (BLOBs)

lo_unlink()

Large Objects (BLOBs)

local

no title | Local to Local | Examples

locking

no title | Locking to Deadlocks | no title | LOCK to SQL92

log()

lower()

lpad()

lseg

macaddr

Installed Types | Network to Network

make

Compile the C Code

masklen()

matrix

see array

max

merge join

see join, merge

min

move

no title | Cursors to Cursors | no title | MOVE to SQL92

nested loop join

see join, nested loop

nested query

see subquery

netmask()

network()

nextval()

Creating Sequences to Using Sequences to Number

normalization

Joined Tables

not like

Support Operators

notify

no title to LISTEN and NOTIFY | PostgreSQL Nonstandard Features by | no title | NOTIFY to SQL92

now()

null

no title | Using NULL Values to Using NULL Values | Controlling DEFAULT Values | Controlling DEFAULT Values | no title to NOT NULL

aggregate: Aggregates | Aggregates
check: CHECK
copy: no title | Backslashes and NULL Values to Backslashes and NULL Values
foreign key: Modification of Primary Key | Modification of Primary Key | no title | Handling NULL Values in to Handling NULL Values in
functions: Support Functions
group by: Using GROUP BY
outer join: Outer Joins
primary key: PRIMARY KEY
psql: Output Format Options | Output Format Options
subquery: no title | NOT IN and Subqueries NULL to NOT IN and Subqueries NULL
trigger: Triggers
unique index: Unique Indexes

nullif()

numeric()

Data Types | Installed Types | Number to Number | Number

object id

copy: COPY Tips
large object: Large Objects (BLOBs)
psql: Variables
system tables: System Tables

octet_length()

Odbc

office productivity applications

Introduction

offset

see limit

oid

see object id

on_error_continue()

Pgeasy (LIBPGEASY)

opaque

Triggers

open source software

no title | Open Source Software to Open Source Software

operator

creation: no title | Create Operators, Types, and to Create Operators, Types, and | no title | CREATE OPERATOR to SQL92
listing: Listing Commands
precedence: Functions and Operators to Functions and Operators

or

no title | AND/OR Usage to AND/OR Usage

order by

see select, order by

outer join

see join, outer

overlaps()

Support Functions | Support Operators

parser error

Creating Tables | Quotes Inside Text

password

Local | User Mappings | User Mappings | Examples

path

performance

see administration, performance

Perl

permission

no title to GRANT and REVOKE | no title to SQL92 | no title to SQL92

listing: Listing Commands

pg_ctl

Server Start-up and Shutdown | Server Start-up and Shutdown | no title | pg_ctl to postmaster status

pg_dump

Backup and Restore | no title | pg_dump to Usage

pg_dumpall

pg_passwd

User Mappings | no title | pg_passwd to Description

pg_upgrade

Upgrading | no title | pg_upgrade to Upgrading Postgres with pg_upgrade

pgaccess

pgclientencoding

Examples

pgdatabase

Examples

pgdatestyle

Examples | Internationalization

pghost

pgpassword

pgport

pgtz

pguser

Php

Programming Interfaces | no title to PHP | Installing Scripting Languages | 2.2) What tools are POSTGRESQL | 2.4) What languages are POSTGRESQL?

pl/pgsql

see function, pl/pgsql

point

polygon

position()

postgres

see administration, server

Postgres95

Foreword to Foreword | University of California at | POSTGRESQL Global Development Team | 1.1) What is POSTGRESQL?

PostgreSQL Global Development Team

Acknowledgments to Non-code Contributors | no title | POSTGRESQL Global Development Team to POSTGRESQL Global Development Team

postmaster

see administration, server

PQclear()

PQconnectdb()

PQexec()

PQfinish()

PQgetvalue()

PQntuples()

primary key

see constraint, primary key

index creation: PRIMARY KEY

programming

no title | Programming Interfaces to Summary | no title | Extending POSTGRESQL Using C to Summary

compiling: no title | Compiling Programs to Compiling Programs
scripting: no title | Scripting Languages to Scripting Languages | no title | Installing Scripting Languages to Installing Scripting Languages
server-side: no title | Functions and Triggers to Summary | PostgreSQL Nonstandard Features by
variables: no title | Assignment to Program Variables to Assignment to Program Variables

ps

Monitoring

psql

buffer commands: no title | Query Buffer Commands to Query Buffer Commands
command args: no title | Psql Command-line Arguments and to Psql Command-line Arguments and
copy: COPY Tips
format commands: no title | Output Format Options to Output Format Shortcuts
general commands: no title | General Commands to General Commands
help: Getting Help to Getting Help
internal queries: no title to 4.4) How do I psql? | no title to 4.8) How do I database?
large object: no title | Large Object Commands to Large Object Commands
listing: no title | Listing Commands | Listing Commands to Listing Commands
prompt: Adding Data with INSERT to Adding Data with INSERT | Comments to Comments
variables: no title | Variables to Variables

Python

Programming Interfaces | no title | Python to Python | Installing Scripting Languages | 2.4) What languages are POSTGRESQL?

quotes

Adding Data with INSERT | Selecting Specific Rows with WHERE | no title | Quotes Inside Text to Quotes Inside Text

around identifiers: Creating Joined Tables to Creating Joined Tables

raise exception

Triggers

rdbms

see relational database

read committed

no title | Read Committed and Serializable to Read Committed and Serializable

referential integrity

no title to Frequency of Foreign Key

regular expression

see where, regular expression

reject

Local

relation does not exist

Viewing Data with SELECT

relational database

reset

no title to SET, SHOW, and RESET | PostgreSQL Nonstandard Features by | no title | RESET to SQL92

restore

see administration, restore

revoke

no title to GRANT and REVOKE | no title to SQL92

round()

rpad()

rule

compared to trigger: no title | Triggers to Triggers
grant: GRANT and REVOKE
listing: System Tables

scripting

see programming, scripting

sed

COPY File Format

select

Controlling a Session | no title to Viewing Data with SELECT | no title | SELECT to Description

and insert

no title to Inserting Data Using SELECT

column label

create table

no title to Creating Tables Using SELECT

cursor

no title | Cursors to Cursors

distinct

no title | Distinct Rows to Distinct Rows

for update

Locking to Locking

grant

GRANT and REVOKE

group by

no title to Using GROUP BY | Three- and Four-Table Joins | Subqueries as Constants

having

no title to Using HAVING | Subqueries as Constants | Subqueries as Correlated Values

into

no title to Creating Tables Using SELECT | Temporary Tables | COPY Tips

limit

no title to LIMIT | no title | 4.3) How do I SELECT to 4.3) How do I SELECT | PostgreSQL Nonstandard Features by

order by

no title to Sorting Data with ORDER BY | Using GROUP BY | UNION, EXCEPT, and INTERSECT | 4.9) My queries are Why?

cluster: CLUSTER
descending: Sorting Data with ORDER BY
index: Indexes | EXPLAIN
limit: LIMIT
union: UNION, EXCEPT, and INTERSECT

subquery

see subquery

self join

see join, self

sequence

listing: Listing Commands

sequential scan

EXPLAIN

serial

no title | Serial Column Type to Serial Column Type | no title | 4.16.1) How do I to 4.16.3) Don't currval() and nextval() | PostgreSQL Nonstandard Features by

serializable

no title | Read Committed and Serializable to Read Committed and Serializable | Locking

server

see administration, server

server-side programming

see programming, server-side

set

setval()

Creating Sequences to Creating Sequences

show

no title to SET, SHOW, and RESET | PostgreSQL Nonstandard Features by | no title | SHOW to SQL92

spi

Write the C Code

sql function

see function, sql

sqrt()

University of California at | 1.1) What is POSTGRESQL?

Ssl

Host and Hostssl

stdin

COPY Without Files | COPY Tips

stdout

COPY Without Files | COPY Without Files | COPY Tips

Stonebraker, Michael

stored procedures

Functions and Triggers

strpos()

subquery

no title | Subqueries to ANY, ALL, and EXISTS | no title | Subqueries in Non-SELECT Queries to Subqueries in Non-SELECT Queries

any, all, exists: no title | ANY, ALL, and EXISTS to ANY, ALL, and EXISTS
constant: no title | Subqueries as Constants to Subqueries as Constants
correlated: no title | Subqueries as Correlated Values to Subqueries as Correlated Values | ANY, ALL, and EXISTS | ANY, ALL, and EXISTS
in: no title | Subqueries as Lists of to NOT IN and Subqueries NULL | ANY, ALL, and EXISTS to ANY, ALL, and EXISTS
multicolumn: no title | Subqueries Returning Multiple Columns to Subqueries Returning Multiple Columns
non-select: no title | Subqueries in Non-SELECT Queries to Subqueries in Non-SELECT Queries
not in: no title | Subqueries as Lists of to NOT IN and Subqueries NULL | ANY, ALL, and EXISTS to ANY, ALL, and EXISTS
nulls: no title | NOT IN and Subqueries NULL to NOT IN and Subqueries NULL
performance: no title | 4.23) Why are my IN to 4.23) Why are my IN
returning multiple values: no title | Subqueries as Lists of to Subqueries as Lists of

subselect

see subquery

substr()

substring()

sum

no title | SQL Aggregates to Using GROUP BY | Ordering Multiple Parts

system tables

Files | no title | System Tables to System Tables

listing: Listing Commands

tab

COPY File Format | DELIMITERS

table

alias: Table and Column References to Table and Column References | no title | Table Aliases and Self-joins to Table Aliases and Self-joins
alter: no title to ALTER TABLE | no title | 4.5) How do you to 4.5) How do you | no title | ALTER TABLE to SQL92
creation: no title | Creating Tables to Creating Tables | no title | CREATE TABLE to Description | no title | SELECT INTO to Description
destruction: no title | Destroying Tables to Destroying Tables | no title | DROP TABLE to SQL92
master/detail: Ordering Multiple Parts
naming: Creating Joined Tables to Creating Joined Tables
permissions: no title to GRANT and REVOKE | no title | Views to Views | Creating Users | no title to SQL92 | no title to SQL92
system: see system tables
temporary: no title | Temporary Tables to Temporary Tables | COPY Tips

Tcl/Tk

template1

Creating Databases | Creating Databases | Initialization | Starting the Server

temporary table

see table, temporary

text

Installed Types | no title | Character String to Character String | Assignment to Program Variables to Assignment to Program Variables

time

Data Types | Installed Types | Temporal to Temporal

time zone

SET, SHOW, and RESET to SET, SHOW, and RESET

time, current

Support Variables

timeofday()

timestamp

Data Types | Installed Types | Temporal to Temporal

current: Controlling a Session | Controlling DEFAULT Values | Support Variables | Rules | Description

to_char()

Support Functions | Support Functions

to_date()

to_number()

to_timestamp()

transaction

cursor: Cursors
deadlock: no title | Deadlocks to Deadlocks
foreign key: Frequency of Foreign Key | Frequency of Foreign Key
isolation level: no title | Read Committed and Serializable to Read Committed and Serializable | Locking | Locking
multistatement: no title | Multistatement Transactions to Multistatement Transactions
rollback: Multistatement Transactions to Multistatement Transactions | no title | ABORT to SQL92 | no title | ROLLBACK to SQL92
visibility: no title | Visibility of Committed Transactions to Visibility of Committed Transactions

translate()

trigger

trim()

Support Functions | CHECK | SQL Functions

true

see boolean

trunc()