Documentation → PostgreSQL 7.4

Supported Versions: Current (18) / 17 / 16 / 15 / 14

Development Versions: devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 7.4.30 Documentation
Prev	Fast Backward

Index

Symbols

$, Positional Parameters
$libdir, Dynamic Loading
*, Select-List Items
.pgpass, The Password File

A

ABORT, ABORT

aggregate function, Aggregate Functions

built-in, Aggregate Functions
invocation, Aggregate Expressions
user-defined, User-Defined Aggregates

alias

for table name in query, Joins Between Tables
in the FROM clause, Table and Column Aliases
in the select list, Column Labels

ALL, Subquery Expressions, Row and Array Comparisons

ALTER AGGREGATE, ALTER AGGREGATE

ALTER CONVERSION, ALTER CONVERSION

ALTER DATABASE, ALTER DATABASE

ALTER DOMAIN, ALTER DOMAIN

ALTER FUNCTION, ALTER FUNCTION

ALTER GROUP, ALTER GROUP

ALTER LANGUAGE, ALTER LANGUAGE

ALTER OPERATOR CLASS, ALTER OPERATOR CLASS

ALTER SCHEMA, ALTER SCHEMA

ALTER SEQUENCE, ALTER SEQUENCE

ALTER TABLE, ALTER TABLE

ALTER TRIGGER, ALTER TRIGGER

ALTER USER, User Attributes, ALTER USER

ANALYZE, Updating planner statistics, ANALYZE

AND (operator), Logical Operators

any, Pseudo-Types, Subquery Expressions, Row and Array Comparisons

anyarray, Pseudo-Types

anyelement, Pseudo-Types

array, Arrays

constant, Array Value Input
constructor, Array Constructors
determination of result type, UNION, CASE, and ARRAY Constructs
of user-defined type, User-Defined Types

auto-increment

see serial

autocommit, Disable Autocommit

average, Aggregate Functions, Aggregate Functions

B

B-tree

see index

backslash_quote configuration parameter, Previous PostgreSQL Versions

backup, Backup and Restore

base type, The PostgreSQL Type System

BEGIN, BEGIN

between, Comparison Operators

bigint, Numeric Constants, Integer Types

bigserial, Serial Types

binary data, Binary Data Types

functions, Binary String Functions and Operators

binary string

concatenation, Binary String Functions and Operators
length, Binary String Functions and Operators

bison, Requirements

bit string

constant, Bit-String Constants
data type, Bit String Types

BLOB

see large object

Boolean

data type, Boolean Type

operators

see operators, logical

booting

starting the server during, Starting the Database Server

box (data type), Boxes

BSD/OS

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions

bytea, Binary Data Types

in JDBC, Storing Binary Data
in libpq, Escaping Binary Strings for Inclusion in SQL Commands

C

C, libpq - C Library, ECPG - Embedded SQL in C

canceling

SQL command, Asynchronous Command Processing

CASCADE

with DROP, Dependency Tracking
foreign key action, Foreign Keys

CASE, Conditional Expressions

determination of result type, UNION, CASE, and ARRAY Constructs

case sensitivity

of SQL commands, Identifiers and Key Words

char, Character Types

character, Character Types

character set, Locale and Formatting, Character Set Support

character string

concatenation, String Functions and Operators
constant, String Constants
data types, Character Types
length, String Functions and Operators

character varying, Character Types

check constraint, Check Constraints

checkpoint, WAL Configuration, CHECKPOINT

cid, Object Identifier Types

cidr, cidr

circle, Circles

class path, Setting up the Class Path

CLASSPATH, Setting up the Class Path

client authentication, Client Authentication

timeout during, Security and Authentication

CLOSE, CLOSE

CLUSTER, CLUSTER

of databases

see database cluster

clusterdb, clusterdb

cmax, System Columns

cmin, System Columns

COALESCE, COALESCE

column, Concepts, Table Basics

adding, Adding a Column
removing, Removing a Column
renaming, Renaming a Column
system column, System Columns

column reference, Column References

col_description, Miscellaneous Functions

COMMENT, COMMENT

about database objects, Miscellaneous Functions
in SQL, Comments

COMMIT, COMMIT

comparison

of rows, Row-wise Comparison
operators, Comparison Operators

compiling

libpq applications, Building libpq Programs

composite type, The PostgreSQL Type System

concurrency, Concurrency Control

conditional expression, Conditional Expressions

configuration

of the server, Run-time Configuration

of the server

functions, Miscellaneous Functions

configure, Installation Procedure

conjunction, Logical Operators

connection pool

in JDBC, Connection Pools and Data Sources

constant, Constants

constraint, Constraints

adding, Adding a Constraint
check, Check Constraints
foreign key, Foreign Keys
name, Check Constraints
NOT NULL, Not-Null Constraints
primary key, Primary Keys
removing, Removing a Constraint
unique, Unique Constraints

COPY, Populating a Table With Rows, COPY

with libpq, Functions Associated with the COPY Command

count, Aggregate Functions

CREATE AGGREGATE, CREATE AGGREGATE

CREATE CAST, CREATE CAST

CREATE CONSTRAINT, CREATE CONSTRAINT TRIGGER

CREATE CONVERSION, CREATE CONVERSION

CREATE DATABASE, Creating a Database, CREATE DATABASE

CREATE DOMAIN, CREATE DOMAIN

CREATE FUNCTION, CREATE FUNCTION

CREATE GROUP, CREATE GROUP

CREATE INDEX, CREATE INDEX

CREATE LANGUAGE, CREATE LANGUAGE

CREATE OPERATOR, CREATE OPERATOR

CREATE OPERATOR CLASS, CREATE OPERATOR CLASS

CREATE RULE, CREATE RULE

CREATE SCHEMA, CREATE SCHEMA

CREATE SEQUENCE, CREATE SEQUENCE

CREATE TABLE, Creating a New Table, CREATE TABLE

CREATE TABLE AS, CREATE TABLE AS

CREATE TRIGGER, CREATE TRIGGER

CREATE TYPE, CREATE TYPE

CREATE USER, Database Users, CREATE USER

CREATE VIEW, CREATE VIEW

createdb, Creating a Database, Creating a Database, createdb

createlang, createlang

createuser, Database Users, createuser

cross join, Joined Tables

crypt, Password authentication

thread safety, Behavior in Threaded Programs

cstring, Pseudo-Types

ctid, System Columns, View Rules in Non-SELECT Statements

currval, Sequence-Manipulation Functions

cursor

in PL/pgSQL, Cursors

D

data area

see database cluster

data type, Data Types

base, The PostgreSQL Type System
category, Overview
composite, The PostgreSQL Type System
constant, Constants of Other Types
conversion, Type Conversion
internal organisation, Base Types in C-Language Functions
numeric, Numeric Types
type cast, Type Casts
user-defined, User-Defined Types

database, Managing Databases

creating,