Index

Symbols

$libdir, Dynamic Loading

A

aggregate, Aggregate Functions

aggregate functions, Aggregate Expressions

extending, Extending SQL: Aggregates

alias

See label

for table name in query, Joins Between Tables

all, Subquery Expressions

and

operator, Logical Operators

any, Pseudo-Types, Subquery Expressions

anyarray, Pseudo-Types

arrays, Arrays, Extending SQL: Types

constants, Array constants

Australian time zones, General Operation

auto-increment

See serial

autocommit, General Operation

average, Aggregate Functions

function, Aggregate Functions

B

B-tree

See indexes

backup, Backup and Restore

between, Comparison Operators

bigint, Numeric Types

bigserial, The Serial Types

binary strings

concatenation, Binary String Functions and Operators

length, Binary String Functions and Operators

bison, Requirements

bit strings

constants, Bit-String Constants

data type, Bit String Types

BLOB

See large object

Boolean

data type, Boolean Type

operators

See operators, logical

box (data type), Box

BSD/OS, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

C

case, Conditional Expressions

case sensitivity

SQL commands, Identifiers and Key Words

catalogs, About the PostgreSQL System Catalogs

character set encoding, General Operation

character strings

concatenation, String Functions and Operators

constants, String Constants

data types, Character Types

length, String Functions and Operators

cid, Object Identifier Types

cidr, cidr

circle, Circle

client authentication, Client Authentication

cluster, Concepts

column, Concepts

columns

system columns, System Columns

col_description, Miscellaneous Functions

comments

in SQL, Comments

comparison

operators, Comparison Operators

concurrency, Concurrency Control

conditionals, Conditional Expressions

configuration

server, Run-time Configuration

configure, Installation Procedure

connection loss, pg_on_connection_loss

constants, Constants

COPY, Populating a Table With Rows

with libpq, Functions Associated with the COPY Command

count, Aggregate Functions

CREATE TABLE, Creating a New Table

createdb, Creating a Database

crypt, Password authentication

cstring, Pseudo-Types

currval, Sequence-Manipulation Functions

D

data area

See database cluster

data types, Data Types, The PostgreSQL Type System

constants, Constants of Other Types

extending, Extending SQL: Types

numeric, Numeric Types

type casts, Type Casts

database, Managing Databases

creating, Creating a Database

database cluster, Creating a Database Cluster

date

constants, Special values

current, Current Date/Time

data type, Dates

output format, Date/Time Output

See also Formatting

date style, General Operation

deadlock

timeout, General Operation

decimal

See numeric

DELETE, Deletions

Digital UNIX

See Tru64 UNIX

dirty read, Transaction Isolation

disk space, Recovering disk space

disk usage, Determining Disk Usage

DISTINCT, Querying a Table, DISTINCT

double precision, Numeric Types

DROP TABLE, Creating a New Table

duplicate, Querying a Table

dynamic loading, General Operation

dynamic_library_path, General Operation, Dynamic Loading

E

elog, Database Access from PL/Tcl

PL/Perl, Database Access from PL/Perl

embedded SQL

in C, ECPG - Embedded SQL in C

environment variables, Environment Variables

error message, Database Connection Functions

escaping binary strings, Escaping binary strings for inclusion in SQL queries

escaping strings, Escaping strings for inclusion in SQL queries

except, Combining Queries

exists, Subquery Expressions

extending SQL, Extending SQL: An Overview

types, The PostgreSQL Type System

F

false, Boolean Type

FETCH

embedded SQL, Porting From Other RDBMS Packages

files, Files

flex, Requirements

float4

See real

float8

See double precision

floating point, Numeric Types

foreign key, Foreign Keys

formatting, Data Type Formatting Functions

FreeBSD, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

fsync, General Operation

function, Extending SQL: Functions, Table Functions

internal, Internal Functions

SQL, Query Language (SQL) Functions

functions, Functions and Operators

G

genetic query optimization, Planner and Optimizer Tuning

GEQO

See genetic query optimization

group, The GROUP BY and HAVING Clauses

GROUP BY, Aggregate Functions

H

hash

See indexes

has_database_privilege, Miscellaneous Functions

has_function_privilege, Miscellaneous Functions

has_language_privilege, Miscellaneous Functions

has_schema_privilege, Miscellaneous Functions

has_table_privilege, Miscellaneous Functions

HAVING, Aggregate Functions

hierarchical database, Concepts

HP-UX, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

I

ident, Ident-based authentication

identifiers, Identifiers and Key Words

in, Subquery Expressions

index scan, Planner and Optimizer Tuning

indexes, Indexes

B-tree, Index Types

hash, Index Types

multicolumn, Multicolumn Indexes

on functions, Functional Indexes

partial, Partial Indexes

R-tree, Index Types

unique, Unique Indexes

inet (data type), inet

inheritance, Inheritance, General Operation

initlocation, Alternative Locations

input function, Extending SQL: Types

INSERT, Populating a Table With Rows

installation, Installation Instructions

on Windows, Requirements, Installation on Windows

int2

See smallint

int4

See integer

int8

See bigint

integer, Numeric Types

internal, Pseudo-Types

intersection, Combining Queries

interval, Intervals

IRIX, Compiling and Linking Dynamically-Loaded Functions

IS NULL, General Operation

isolation levels, Transaction Isolation

read committed, Read Committed Isolation Level

read serializable, Serializable Isolation Level

J

join, Joins Between Tables

outer, Joins Between Tables

self, Joins Between Tables

joins, Joined Tables

cross, Joined Tables

left, Joined Tables

natural, Joined Tables

outer, Joined Tables

K

Kerberos, Kerberos authentication

key words

list of, SQL Key Words

syntax, Identifiers and Key Words

L

label

column, Column Labels

table, Table and Column Aliases

language_handler, Pseudo-Types

large object, Large Objects

LC_COLLATE, Creating a Database Cluster

ldconfig, Shared Libraries

length

binary strings

See binary strings, length

character strings

See character strings, length

libperl, Requirements

libpgtcl, pgtcl - Tcl Binding Library

libpq, libpq - C Library

libpq-fe.h, Database Connection Functions

libpq-int.h, Database Connection Functions, Building Libpq Programs

libpython, Requirements

like, LIKE

limit, LIMIT and OFFSET

line, Line Segment

Linux, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

locale, Creating a Database Cluster, Locale Support

locking, Explicit Locking

log files, Log File Maintenance

M

MAC address

See macaddr

macaddr (data type), macaddr

MacOS X, Compiling and Linking Dynamically-Loaded Functions

make, Requirements

MANPATH, Environment Variables

See also man pages

max, Aggregate Functions

MD5, Password authentication

min, Aggregate Functions

multibyte, Multibyte Support

N

names

qualified, Creating a Schema

unqualified, The Schema Search Path

namespaces, Schemas, General Operation

NetBSD, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

network

addresses, Network Address Data Types

nextval, Sequence-Manipulation Functions

nonblocking connection, Database Connection Functions, Asynchronous Query Processing

nonrepeatable read, Transaction Isolation

not

operator, Logical Operators

not in, Subquery Expressions

notice processor, libpq Control Functions

NOTIFY, Asynchronous Notification, pg_listen

nullif, NULLIF

numeric

constants, Numeric Constants

numeric (data type), Numeric Types

O

object identifier

data type, Object Identifier Types

object-oriented database, Concepts

obj_description, Miscellaneous Functions

offset

with query results, LIMIT and OFFSET

OID, System Columns, Object Identifier Types

opaque, Pseudo-Types

OpenBSD, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

OpenSSL, Installation Procedure

See also SSL

operators, Functions and Operators

logical, Logical Operators

precedence, Lexical Precedence

syntax, Operators

or

operator, Logical Operators

Oracle, Porting From Other RDBMS Packages, Porting from Oracle PL/SQL

ORDER BY, Querying a Table, Benefits

OS/X, Shared Memory and Semaphores

output function, Extending SQL: Types

overlay, String Functions and Operators

overloading, Function Overloading

P

password, Password authentication

.pgpass, Files

PATH, Environment Variables

path (data type), Path

Perl, PL/Perl - Perl Procedural Language

PGDATA, Creating a Database Cluster

PGDATABASE, Environment Variables

PGHOST, Environment Variables

PGPASSWORD, Environment Variables

PGPORT, Environment Variables

pgtcl

closing, pg_lo_close

connecting, pg_connect, pg_disconnect, pg_conndefaults, pg_exec, pg_result, pg_select

connection loss, pg_on_connection_loss

creating, pg_lo_creat

delete, pg_lo_unlink

export, pg_lo_export

import, pg_lo_import

notify, pg_listen

opening, pg_lo_open

positioning, pg_lo_lseek, pg_lo_tell

query, pg_execute

reading, pg_lo_read

writing, pg_lo_write

PGUSER, Environment Variables

pg_config, Building Libpq Programs, Writing Code

pg_conndefaults, pg_conndefaults

pg_connect, pg_connect, pg_disconnect, pg_exec, pg_result, pg_select

pg_ctl, Starting the Database Server

pg_dumpall, If You Are Upgrading

pg_execute, pg_execute

pg_function_is_visible, Miscellaneous Functions

pg_get_constraintdef, Miscellaneous Functions

pg_get_indexdef, Miscellaneous Functions

pg_get_ruledef, Miscellaneous Functions

pg_get_userbyid, Miscellaneous Functions

pg_get_viewdef, Miscellaneous Functions

pg_hba.conf, The pg_hba.conf file

pg_ident.conf, Ident Maps

pg_lo_close, pg_lo_close

pg_lo_creat, pg_lo_creat

pg_lo_export, pg_lo_export

pg_lo_import, pg_lo_import

pg_lo_lseek, pg_lo_lseek

pg_lo_open, pg_lo_open

pg_lo_read, pg_lo_read

pg_lo_tell, pg_lo_tell

pg_lo_unlink, pg_lo_unlink

pg_lo_write, pg_lo_write

pg_opclass_is_visible, Miscellaneous Functions

pg_operator_is_visible, Miscellaneous Functions

pg_table_is_visible, Miscellaneous Functions

pg_type_is_visible, Miscellaneous Functions

phantom read, Transaction Isolation

PIC, Compiling and Linking Dynamically-Loaded Functions

PL/Perl, PL/Perl - Perl Procedural Language

PL/pgSQL, PL/pgSQL - SQL Procedural Language

PL/Python, PL/Python - Python Procedural Language

PL/SQL, Porting from Oracle PL/SQL

PL/Tcl, PL/Tcl - Tcl Procedural Language

point, Point

polygon, Polygon

port, General Operation

postgres user, The PostgreSQL User Account

postmaster, Architectural Fundamentals, Starting the Database Server

ps

to monitor activity, Standard Unix Tools

psql, Accessing a Database

Python, PL/Python - Python Procedural Language

Q

qualified names, Creating a Schema

query, Querying a Table

quotes

and identifiers, Identifiers and Key Words

escaping, String Constants

R

R-tree

See indexes

range table, The Parts of a Query tree

readline, Requirements

real, Numeric Types

record, Pseudo-Types

referential integrity, Foreign Keys

regclass, Object Identifier Types

regoper, Object Identifier Types

regoperator, Object Identifier Types

regproc, Object Identifier Types

regprocedure, Object Identifier Types

regression test, Installation Procedure

regtype, Object Identifier Types

regular expressions, SIMILAR TO and SQL99 Regular Expressions, POSIX Regular Expressions

See also pattern matching

reindex, Routine Reindexing

relation, Concepts

relational database, Concepts

row, Concepts

rules, The Rule System

and views, Views and the Rule System

S

schema

current, Miscellaneous Functions

schemas, Schemas

current schema, General Operation

SCO OpenServer, Shared Memory and Semaphores

search path, The Schema Search Path

changing at runtime, Miscellaneous Functions

current, Miscellaneous Functions

search_path, General Operation

SELECT, Querying a Table

select list, Select Lists

semaphores, Shared Memory and Semaphores

sequences, Sequence-Manipulation Functions

and serial type, The Serial Types

sequential scan, Planner and Optimizer Tuning

serial, The Serial Types

serial4, The Serial Types

serial8, The Serial Types

SETOF, Query Language (SQL) Functions

See also function

setting

current, Miscellaneous Functions

set, Miscellaneous Functions

setval, Sequence-Manipulation Functions

shared libraries, Shared Libraries

shared memory, Shared Memory and Semaphores

SHMMAX, Shared Memory and Semaphores

SIGHUP, Run-time Configuration, The pg_hba.conf file, Ident Maps

similar to, SIMILAR TO and SQL99 Regular Expressions

sliced bread

See TOAST

smallint, Numeric Types

Solaris, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

some, Subquery Expressions

sorting

query results, Sorting Rows

SPI

allocating space, SPI_palloc, SPI_repalloc, SPI_pfree, SPI_freetuple, SPI_freetuptable, SPI_freeplan

connecting, SPI_connect, SPI_prepare, SPI_execp, SPI_saveplan

copying tuple descriptors, SPI_copytupledesc

copying tuples, SPI_copytuple, SPI_copytupleintoslot

cursors, SPI_cursor_open, SPI_cursor_find, SPI_cursor_fetch, SPI_cursor_move, SPI_cursor_close

decoding tuples, SPI_fnumber, SPI_fname, SPI_getvalue, SPI_getbinval, SPI_gettype, SPI_gettypeid, SPI_getrelname

disconnecting, SPI_finish

executing, SPI_exec

modifying tuples, SPI_modifytuple

SPI_connect, SPI_connect

SPI_copytuple, SPI_copytuple

SPI_copytupledesc, SPI_copytupledesc

SPI_copytupleintoslot, SPI_copytupleintoslot

SPI_cursor_close, SPI_cursor_close

SPI_cursor_fetch, SPI_cursor_fetch

SPI_cursor_find, SPI_cursor_find

SPI_cursor_move, SPI_cursor_move

SPI_cursor_open, SPI_cursor_open

SPI_exec, SPI_exec

SPI_execp, SPI_execp

SPI_finish, SPI_finish

SPI_fname, SPI_fname

SPI_fnumber, SPI_fnumber

SPI_freeplan, SPI_freeplan

SPI_freetuple, SPI_freetuple

SPI_freetuptable, SPI_freetuptable

SPI_getbinval, SPI_getbinval

SPI_getrelname, SPI_getrelname

SPI_gettype, SPI_gettype

SPI_gettypeid, SPI_gettypeid

SPI_getvalue, SPI_getvalue

spi_lastoid, Database Access from PL/Tcl

SPI_modifytuple, SPI_modifytuple

SPI_palloc, SPI_palloc

SPI_pfree, SPI_pfree

SPI_prepare, SPI_prepare

SPI_repalloc, SPI_repalloc

SPI_saveplan, SPI_saveplan

ssh, Secure TCP/IP Connections with SSH Tunnels

SSL, General Operation, Secure TCP/IP Connections with SSL, Database Connection Functions

standard deviation, Aggregate Functions

statistics, Statistics Collector

strings

See character strings

subqueries, Subqueries, Subquery Expressions

subquery, Aggregate Functions

substring, String Functions and Operators, Binary String Functions and Operators, SIMILAR TO and SQL99 Regular Expressions

sum, Aggregate Functions

superuser, Accessing a Database

syntax

SQL, SQL Syntax

T

table, Concepts

Tcl, pgtcl - Tcl Binding Library, PL/Tcl - Tcl Procedural Language

TCP/IP, Starting the Database Server

text

See character strings

threads

with libpq, Threading Behavior

tid, Object Identifier Types

time

constants, Special values

current, Current Date/Time

data type, Times

output format, Date/Time Output

See also Formatting

time with time zone

data type, Times

time without time zone

time, Times

time zone, General Operation

time zones, Time Zones, Date/Time Key Words

timeout

authentication, General Operation

deadlock, General Operation

timestamp

data type, Time stamps

timestamp with time zone

data type, Time stamps

timestamp without time zone

data type, Time stamps

timezone

conversion, AT TIME ZONE

TOAST, Introduction

and user-defined types, Extending SQL: Types

transaction ID

wraparound, Preventing transaction ID wraparound failures

transaction isolation level, General Operation

transactions, Transactions

trigger, Pseudo-Types

triggers

in PL/Tcl, Trigger Procedures in PL/Tcl

Tru64 UNIX, Compiling and Linking Dynamically-Loaded Functions

true, Boolean Type

types

See data types

U

union, Combining Queries

UnixWare, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

unqualified names, The Schema Search Path

UPDATE, Updates

upgrading, If You Are Upgrading, Migration between releases

user

current, Miscellaneous Functions

V

vacuum, Routine Vacuuming

variance, Aggregate Functions

version, Accessing a Database, Miscellaneous Functions

view, Views

views

updating, What about updating a view?

void, Pseudo-Types

W

where, The WHERE Clause

X

xid, Object Identifier Types

Y

yacc, Requirements