Documentation
 
 
 

Index

A

abs, Mathematical Functions and Operators
ActiveX Data Objects
Using ADO with ODBC, Using ADO with ODBC
ADO, Using ADO with ODBC
aggregate function, Aggregate Functions
invocation, Aggregate Expressions
Aggregate Functions
built-in, Aggregate Functions
AIX
IPC configuration, Shared Memory and Semaphores
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
ALTER DATABASE, Description
ALTER FUNCTION, Description
ALTER GROUP, Description
ALTER INDEX, Description
ALTER OPERATOR, Description
ALTER ROLE, Role Attributes, Description
ALTER SCHEMA, Description
ALTER SEQUENCE, Description
ALTER TABLE, Description
ALTER TABLESPACE, Description
ALTER TRIGGER, Description
ALTER TYPE, Description
ALTER USER, Description
ANALYZE, Updating planner statistics, Description
AND (operator), Logical Operators
ANY, Aggregate Functions, Subquery Expressions
archive_command configuration parameter, Archiving
ascii, String Functions and Operators
australian_timezones configuration parameter, Locale and Formatting
authentication_timeout configuration parameter, Security and Authentication
autocommit
bulk-loading data, Disable Autocommit
EnterpriseDB PSQL, Variables
autovacuum
global configuration parameters, Automatic Vacuuming
table-specific configuration, pg_autovacuum
autovacuum configuration parameter, Automatic Vacuuming
autovacuum_analyze_scale_factor configuration parameter, Automatic Vacuuming
autovacuum_analyze_threshold configuration parameter, Automatic Vacuuming
autovacuum_naptime configuration parameter, Automatic Vacuuming
autovacuum_vacuum_cost_delay configuration parameter, Automatic Vacuuming
autovacuum_vacuum_cost_limit configuration parameter, Automatic Vacuuming
autovacuum_vacuum_scale_factor configuration parameter, Automatic Vacuuming
autovacuum_vacuum_threshold configuration parameter, Automatic Vacuuming
average, Aggregate Functions, Aggregate Functions

B

B-tree
see index
backup, System Administration Functions, Backup and Restore
BEGIN, Description
BETWEEN, Comparison Operators
bgwriter_all_maxpages configuration parameter, Background Writer
bgwriter_all_percent configuration parameter, Background Writer
bgwriter_delay configuration parameter, Background Writer
bgwriter_lru_maxpages configuration parameter, Background Writer
bgwriter_lru_percent configuration parameter, Background Writer
bigint, Numeric Constants, Integer Types
binary
data types, Binary Data
binary data, Binary Data
functions, Binary String Functions and Operators
binary large object, Binary Data
binary string
concatenation, Binary String Functions and Operators
length, Binary String Functions and Operators
bit
see boolean
bitmap scan, Combining Multiple Indexes, Planner Method Configuration
bit_and, Aggregate Functions
bit_length, String Functions and Operators
bit_or, Aggregate Functions
blob
see binary large object
block_size configuration parameter, Preset Options
bonjour_name configuration parameter, Connection Settings
Boolean
data type, Boolean Type
operators
see operators, logical
bool_and, Aggregate Functions
bool_or, Aggregate Functions
booting
starting the server during, Starting the Database Server
breakpoints, Using Breakpoints
removing, Removing Breakpoints
removing all, Removing all Breakpoints:
setting, Setting Breakpoints
Browsing Oracle Databases, Browsing Oracle Databases
Registering an Oracle Server, Registering an Oracle Server
BSD/OS
IPC configuration, Shared Memory and Semaphores
btrim, String Functions and Operators
buffer cache, Buffer Cache
byte
data types, Binary Data
bytea, Binary Data
in libpq, Escaping Binary Strings for Inclusion in SQL Commands
usage in .NET, Using BYTEA Data Type in a .NET Application
usage in JDBC, Using BYTEA Datatype

C

C, libpq - C Library
Call Stack Frame, Call Stack Frame
canceling
SQL command, Cancelling Queries in Progress
cartesian
product, Joined Tables
cartesian product, Joined Tables
CASCADE
with DROP, Dependency Tracking
foreign key action, Foreign Keys
CASE, Conditional Expressions
case sensitivity
of SQL commands, Identifiers and Key Words
cbrt, Mathematical Functions and Operators
ceiling, Mathematical Functions and Operators
char
see character
char varying
see character varying
character, Character Types
character large object, Character Types
character set, Locale and Formatting, Preset Options, 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
char_length, String Functions and Operators
check constraint, Check Constraints
checkpoint, WAL Configuration, Description
checkpoint_segments configuration parameter, Checkpoints
checkpoint_timeout configuration parameter, Checkpoints
checkpoint_warning configuration parameter, Checkpoints
check_function_bodies configuration parameter, Statement Behavior
chr, String Functions and Operators
client authentication, Client Authentication
timeout during, Security and Authentication
client_encoding configuration parameter, Locale and Formatting
client_min_messages configuration parameter, When To Log
clob
see character large object
CLOSE, Description
CLUSTER, Description
of databases
see database cluster
clusterdb, Description
CMAX
column, System Columns
CMIN
column, 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 privileges, Column Privileges Report
column reference, Column References
column statistics, Column Statistics Report
col_description, System Information Functions
COM
Using ADO with ODBC, Using ADO with ODBC
COMMENT, Description
about database objects, System Information Functions
in SQL, Comments
COMMIT, Description
COMMIT PREPARED, Description
commit_delay configuration parameter, Settings
commit_siblings configuration parameter, Settings
comparison
operators, Comparison Operators
subquery result row, Subquery Expressions
concat, String Functions and Operators
concurrency, Concurrency Control
conditional expression, Conditional Expressions
configuration
of the server, Run-time Configuration
of the server
functions, System Administration Functions
configuration settings, Configuration
config_file configuration parameter, File Locations
conjunction, Logical Operators
connection service file, The Connection Service File
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
constraint exclusion, Partitioning and Constraint Exclusion, Other Planner Options
constraints, Constraints Report
constraint_exclusion configuration parameter, Other Planner Options
Continue, Stepping Through the Code
convert, String Functions and Operators
COPY, Populating a Table With Rows, Description
with libpq, Functions Associated with the COPY Command
count, Aggregate Functions
cpu_index_tuple_cost configuration parameter, Planner Cost Constants
cpu_operator_cost configuration parameter, Planner Cost Constants
cpu_tuple_cost configuration parameter, Planner Cost Constants
CREATE DATABASE, Creating a Database
CREATE DATABASE, Description
CREATE FUNCTION, Description, Description
CREATE GROUP, Description
CREATE INDEX, Description
CREATE OPERATOR, Description
CREATE PROCEDURE, Description
CREATE PUBLIC SYNONYM, Description
CREATE ROLE, Database Roles, Description
CREATE RULE, Description
CREATE SCHEMA, Description
CREATE SEQUENCE, Description
CREATE TABLE, Creating a New Table, Description
CREATE TABLE AS, Description
CREATE TABLESPACE, Tablespaces, Description
CREATE TRIGGER, Description
CREATE TYPE, Description
CREATE USER, Description
CREATE VIEW, Description
createdb, Creating a Database, Description
createuser, Database Roles, createuser
Creating Packages, Creating Packages
crypt, Password authentication
CTID, View Rules in Non-SELECT Statements
column, System Columns
currval, Sequence Manipulation Functions
cursor
CLOSE, Description
DECLARE, Description
FETCH, Description
in SPL, Static Cursors
showing the query plan, Description
strongly typed, REF CURSORS and Cursor Variables
Cursor FOR Loop, Cursor FOR Loop
custom_variable_classes configuration parameter, Version and Platform Compatibility

D

data area
see database cluster
data type, Data Types
conversion, Type Conversion
numeric, Numeric Types
database, Managing Databases
privilege to create, Role Attributes
database activity
monitoring, Monitoring Database Activity
Database Auditing, EnterpriseDB Auditing Settings
database cluster, Concepts, Creating a Database Cluster
database logs, View DB Logs
database maintenance, Database Maintenance
data_directory configuration parameter, File Locations
date, Date/Time Types, Dates
constants, Special Values
current, Current Date/Time
output format, Date/Time Output
see also formatting
Date/Time Functions and Operators
ROUND Function, Date/Time Functions and Operators
DateStyle configuration parameter, Locale and Formatting
datetime, Date/Time Types
DBA Management Server, EnterpriseDB DBA Management Server
see also EnterpriseDB DBA Management Server
DBA Management Server Login, DBA Management Server Login
db_user_namespace configuration parameter, Security and Authentication
deadlock, Deadlocks
timeout during, Lock Management
deadlock_timeout configuration parameter, Lock Management
DEALLOCATE, Description
debug, EnterpriseDB PL Debugger
debugger, EnterpriseDB PL Debugger
Debugging
Continue, Stepping Through the Code
Step Into, Stepping Through the Code
Step Over, Stepping Through the Code
debug_pretty_print configuration parameter, What To Log
debug_print_parse configuration parameter, What To Log
debug_print_plan configuration parameter, What To Log
debug_print_rewritten configuration parameter, What To Log
dec
see decimal
decimal, Arbitrary Precision Numbers
DECLARE, Description
decode, String Functions and Operators
default value, Default Values
changing, Changing the Default
default_statistics_target configuration parameter, Other Planner Options
default_tablespace configuration parameter, Statement Behavior
default_transaction_isolation configuration parameter, Statement Behavior
default_transaction_read_only configuration parameter, Statement Behavior
degrees, Mathematical Functions and Operators
DELETE, Deletions, Deleting Data, Description
in SPL, DELETE
deleting, Deleting Data
desc, EnterpriseDB PSQL
describe, EnterpriseDB PSQL
Developer Studio
connection errors
connection refused, Could not connect to Server: Connection refused
no pg_hba.conf entry, FATAL: no pg_hba.conf entry
Copying Table/View Definition, Viewing and Copying Table/View Definition
debugging, Debugging Programs
displaying table data, Displaying and Updating Data
Editable/Non-editable Resultsets, Using SQL Interactive
Enable/Disable Autocommit, Using SQL Interactive
EnterpriseDB PSQL, Using EnterpriseDB PSQL
Execution Modes, Using SQL Interactive
Explicit Transaction Control, Using SQL Interactive
global break points, Setting Global Break Points
Maintenance
ANALYZE, ANALYZE
Backup, Backup
REINDEX, REINDEX
Restore, Restore
VACUUM, VACUUM
Multiple Tabs for Multiple Resultsets, Using SQL Interactive
register server, Starting Developer Studio
SQL Interactive, Using SQL Interactive
starting, Starting Developer Studio
templates
functions, Creating Functions
packages, Creating Packages
procedures, Creating Procedures
triggers, Creating Triggers
Viewing Table/View Definition, Viewing and Copying Table/View Definition
Visual Explain, Visual Explain
dirty read, Transaction Isolation
disjunction, Logical Operators
disk reads, Database Read/Write Activity Report
disk space, Recovering disk space
disk usage, Determining Disk Usage
DISTINCT, Querying a Table, DISTINCT
double precision, Floating-Point Types
DROP DATABASE, Destroying a Database, Description
DROP FUNCTION, Description
DROP GROUP, Description
DROP INDEX, Description
DROP OPERATOR, Description
DROP PROCEDURE, Description
DROP PUBLIC SYNONYM, Description
DROP ROLE, Database Roles, Description
DROP RULE, Description
DROP SCHEMA, Description
DROP SEQUENCE, Description
DROP TABLE, Creating a New Table, Description
DROP TABLESPACE, Description
DROP TRIGGER, Description
DROP TYPE, Description
DROP USER, Description
DROP VIEW, Description
dropdb, Destroying a Database, Description
dropuser, Database Roles, dropuser
DSN, EnterpriseDB ODBC Connector
duplicate, Querying a Table
duplicates, DISTINCT
dynamic loading, Other Defaults
dynamic sql, Dynamic SQL
dynamic_library_path configuration parameter, Other Defaults

E

ECPG, ECPG - Embedded SQL in C
EDB-POSTGRES (the program), Description
EDB-Postgres catalogs, System Catalogs
edb-postmaster, Starting the Database Server, Description
edb-psql, Description
edb-psql+, EnterpriseDB PSQL
edb_dynatune, Setting the Database Server for Optimal Performance
edb_dynatune configuration parameter, Dynamic Tuning
edb_package, edb_package
edb_pkgelements, edb_pkgelements
edb_redwood_date configuration parameter, Locale and Formatting
effective_cache_size configuration parameter, Planner Cost Constants
Embedded SQL C Preprocessor, ECPG - Embedded SQL in C
Embedded SQL in C, ECPG - Embedded SQL in C
enable_bitmapscan configuration parameter, Planner Method Configuration
enable_hashagg configuration parameter, Planner Method Configuration
enable_hashjoin configuration parameter, Planner Method Configuration
enable_indexscan configuration parameter, Planner Method Configuration
enable_mergejoin configuration parameter, Planner Method Configuration
enable_nestloop configuration parameter, Planner Method Configuration
enable_seqscan configuration parameter, Planner Method Configuration
enable_sort configuration parameter, Planner Method Configuration
enable_tidscan configuration parameter, Planner Method Configuration
encode, String Functions and Operators
END, Description
EnterpriseDB .NET Connector, EnterpriseDB .NET Connector Introduction
EnterpriseDB DBA Management Server, Introduction
Add/Remove Cluster, Add/Remove Cluster
iQuery, iQuery
Messaging, Messaging
MetaData
indexes, Indexes Report
sequences, Sequences Report
tables, Tables Report
views, Views Report
Monitoring, Monitoring
buffer cache, Buffer Cache
lock status, Lock Status Report
runtime configuration, Configuration
user activity, User Activity Report
Procedural Logic
functions, Functions Report
packages, Packages Report
procedures, Procedures Report
triggers, Triggers Report
Query Profiler, Query Profiler
read/write activity, Database Read/Write Activity Report
Reporting, Reporting
Security
column privileges, Column Privileges Report
constraints, Constraints Report
view logs, View DB Logs
to monitor activity, EnterpriseDB DBA Management Server
EnterpriseDB Developer Studio, EnterpriseDB Developer Studio
see also Developer Studio
EnterpriseDB Error Codes, EnterpriseDB Error Codes
EnterpriseDB JDBC Connector, EnterpriseDB JDBC Connector
EnterpriseDB ODBC Connector, EnterpriseDB ODBC Connector
EnterpriseDB PL Debugger, EnterpriseDB PL Debugger
breakpoints, Using Breakpoints
Call Stack Frame, Call Stack Frame
Dehugging a Program, Debugging a Program
Information Bar, Information Bar
Main Debugger Window, Main Debugger Window
Parameter Grid Window, Parameter Grid Window
Program Body Frame, Program Body Frame
restarting, Restarting the PL Debugger
starting, Starting the PL Debugger
Stepping through Code, Stepping Through the Code
stopping, Stopping the PL Debugger
Variable View Frame, Variable View Frame
EnterpriseDB PSQL features
DESC, Features
DESCRIBE, Features
Exit or Quit, Features
L(for query listing), Features
R(for query listing & execution), Features
REM, Features
REMARK, Features
EnterpriseDB Replicationc, EnterpriseDB Replication
enterprisedb user, The enterprisedb User Account
environment variable, Environment Variables
error codes
libpq, Main Functions
error message, Connection Status Functions
escape_string_warning configuration parameter, Version and Platform Compatibility
escaping strings
in libpq, Escaping Strings for Inclusion in SQL Commands
every, Aggregate Functions
EXCEPT, Combining Queries
EXECUTE, Description
EXISTS, Subquery Expressions
exp, Mathematical Functions and Operators
EXPLAIN, Using EXPLAIN, Description
explain_pretty_print configuration parameter, Other Defaults
expression
syntax, Value Expressions
external_pid_file configuration parameter, File Locations
extra_float_digits configuration parameter, Locale and Formatting

F

false, Boolean Type
fast path, The Fast-Path Interface
FETCH, Description
float
see floating point
floating point, Floating-Point Types
floating-point
display, Locale and Formatting
floor, Mathematical Functions and Operators
foreign key, Foreign Keys, Foreign Keys
formatting, Data Type Formatting Functions
FreeBSD
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
from_collapse_limit configuration parameter, Other Planner Options
fsync, Benefits of WAL
fsync configuration parameter, Settings
full_page_writes configuration parameter, Settings
functions, Functions Report

G

genetic query optimization, Genetic Query Optimizer
GEQO
see genetic query optimization
geqo configuration parameter, Genetic Query Optimizer
geqo_effort configuration parameter, Genetic Query Optimizer
geqo_generations configuration parameter, Genetic Query Optimizer
geqo_pool_size configuration parameter, Genetic Query Optimizer
geqo_selection_bias configuration parameter, Genetic Query Optimizer
geqo_threshold configuration parameter, Genetic Query Optimizer
get_bit, Binary String Functions and Operators
get_byte, Binary String Functions and Operators
global break points, Setting Global Break Points
GRANT, Privileges, GRANT
GROUP BY, Aggregate Functions, The GROUP BY and HAVING Clauses
grouping, The GROUP BY and HAVING Clauses

H

hash
see index
has_database_privilege, System Information Functions
has_function_privilege, System Information Functions
has_language_privilege, System Information Functions
has_schema_privilege, System Information Functions
has_tablespace_privilege, System Information Functions
has_table_privilege, System Information Functions
HAVING, Aggregate Functions, The GROUP BY and HAVING Clauses
hba_file configuration parameter, File Locations
hierarchical database, Concepts
Hierarchical Queries, Hierarchical Queries
host name, Database Connection Control Functions
HP-UX
IPC configuration, Shared Memory and Semaphores

I

ident, Ident-based authentication
identifier
syntax of, Identifiers and Key Words
ident_file configuration parameter, File Locations
image
data types, Binary Data
IN, Subquery Expressions
index, Indexes
B-tree, Index Types
combining multiple indexes, Combining Multiple Indexes
examining usage, Examining Index Usage
on expressions, Indexes on Expressions
hash, Index Types
locks, Locking and Indexes
multicolumn, Multicolumn Indexes
partial, Partial Indexes
R-tree, Index Types
unique, Unique Indexes
index information, Indexes Report
index IO, Index IO Detail Report
index scan, Planner Method Configuration
indexes, Indexes Report
Information Bar, Information Bar
inheritance, Inheritance, Inheritance
initcap, String Functions and Operators
initdb, Creating a Database Cluster, Description
INSERT, Populating a Table With Rows, Inserting Data, Description
in SPL, INSERT
inserting, Inserting Data
int
see integer
int8
see bigint
integer, Numeric Constants, Integer Types
integer_datetimes configuration parameter, Preset Options
INTERSECT, Combining Queries
iQuery, iQuery
IS DISTINCT FROM, Comparison Operators
IS FALSE, Comparison Operators
IS NOT FALSE, Comparison Operators
IS NOT NULL, Comparison Operators
IS NOT TRUE, Comparison Operators
IS NOT UNKNOWN, Comparison Operators
IS NULL, Comparison Operators
IS TRUE, Comparison Operators
IS UNKNOWN, Comparison Operators
ISNULL, Comparison Operators

K

Kerberos, Kerberos authentication
key word
syntax of, Identifiers and Key Words
km , Comparison Operators
krb_caseins_users configuration parameter, Security and Authentication
krb_server_hostname configuration parameter, Security and Authentication
krb_server_keyfile configuration parameter, Security and Authentication
krb_srvname configuration parameter, Security and Authentication

L

label
see alias
lc_collate configuration parameter, Preset Options
lc_ctype configuration parameter, Preset Options
lc_messages configuration parameter, Locale and Formatting
lc_monetary configuration parameter, Locale and Formatting
lc_numeric configuration parameter, Locale and Formatting
lc_time configuration parameter, Locale and Formatting
LDAP, LDAP authentication
left join, Joined Tables
length, String Functions and Operators
of a binary string
see binary strings, length
of a character string
see character strings, length
libpq, libpq - C Library
concepts, libpq Concepts
libpq-fe.h, Introduction
LIKE, LIKE
LIMIT, LIMIT and OFFSET
Linux
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
list, EnterpriseDB PSQL
listen_addresses configuration parameter, Connection Settings
ln, Mathematical Functions and Operators
locale, Creating a Database Cluster, Locale Support
lock, Explicit Locking, Table-Level Locks, Description
monitoring, Viewing Locks
lock status, Lock Status Report
log, Mathematical Functions and Operators
login privilege, Role Attributes
logs, View DB Logs
log_connections configuration parameter, What To Log
log_destination configuration parameter, Where to log
log_directory configuration parameter, Where to log
log_disconnections configuration parameter, What To Log
log_duration configuration parameter, What To Log
log_error_verbosity configuration parameter, When To Log
log_executor_stats configuration parameter, Statistics Monitoring
log_filename configuration parameter, Where to log
log_hostname configuration parameter, What To Log
log_line_prefix configuration parameter, What To Log
log_min_duration_statement configuration parameter, When To Log
log_min_error_statement configuration parameter, When To Log
log_min_messages configuration parameter, When To Log
log_parser_stats configuration parameter, Statistics Monitoring
log_planner_stats configuration parameter, Statistics Monitoring
log_rotation_age configuration parameter, Where to log
log_rotation_size configuration parameter, Where to log
log_statement configuration parameter, What To Log
log_statement_stats configuration parameter, Statistics Monitoring
log_truncate_on_rotation configuration parameter, Where to log
long raw, Binary Data
long varchar, Character Types
longtext, Character Types
loop
in SPL, Loops
lower, String Functions and Operators
lo_export, Exporting a Large Object
lo_open, Opening an Existing Large Object
lpad, String Functions and Operators
ltrim, String Functions and Operators
lvarchar, Character Types

M

Main Debugger Window, Main Debugger Window
maintenance, Routine Database Maintenance Tasks
maintenance_work_mem configuration parameter, Memory
mathematical
functions, Mathematical Functions and Operators
operators, Mathematical Functions and Operators
max, Aggregate Functions
max_connections configuration parameter, Connection Settings
max_files_per_process configuration parameter, Kernel Resource Usage
max_fsm_pages configuration parameter, Free Space Map
max_fsm_relations configuration parameter, Free Space Map
max_function_args configuration parameter, Preset Options
max_identifier_length configuration parameter, Preset Options
max_index_keys configuration parameter, Preset Options
max_locks_per_transaction configuration parameter, Lock Management
max_prepared_transactions configuration parameter, Memory
max_stack_depth configuration parameter, Memory
md5, String Functions and Operators, Password authentication
mediumtext, Character Types
memory reads, Database Read/Write Activity Report
Migrating Oracle Databases to EnterpriseDB, Migrating Oracle Databases to EnterpriseDB
min, Aggregate Functions
mod, Mathematical Functions and Operators
money, Arbitrary Precision Numbers
monitoring
database activity, Monitoring Database Activity
MVCC, Introduction

N

name
qualified, Creating a Schema
syntax of, Identifiers and Key Words
unqualified, The Schema Search Path
natural join, Joined Tables
negation, Logical Operators
NetBSD
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
nextval, Sequence Manipulation Functions
nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing
nonrepeatable read, Transaction Isolation
NOT (operator), Logical Operators
NOT IN, Subquery Expressions
not-null constraint, Not-Null Constraints
notice processing
in libpq, Notice Processing
notice processor, Notice Processing
notice receiver, Notice Processing
Notification Handler
usage in JDBC, Notification Handler
NOTIFY
in libpq, Asynchronous Notification
null value
with check constraints, Check Constraints
comparing, Comparison Operators
default value, Default Values
in DISTINCT, DISTINCT
in libpq, Retrieving Query Result Information
with unique constraints, Unique Constraints
NULLIF, NULLIF
number, Arbitrary Precision Numbers
constant, Numeric Constants
numeric, Numeric Constants
numeric (data type), Arbitrary Precision Numbers

O

object-oriented database, Concepts
obj_description, System Information Functions
octet_length, String Functions and Operators
ODBC
Using ADO with ODBC, Using ADO with ODBC
OFFSET, LIMIT and OFFSET
OID
column, System Columns
in libpq, Retrieving Result Information for Other Commands
OLE DB
Using ADO with ODBC, Using ADO with ODBC
on-line backup, Backup and Restore
OpenBSD
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
operator
invocation, Operator Invocations
logical, Logical Operators
precedence, Lexical Precedence
syntax, Operators
operator class, Operator Classes
OR (operator), Logical Operators
Oracle Browsing
Registering an Oracle Server, Registering an Oracle Server
Oracle Error Codes, EnterpriseDB Error Codes
ORDER BY, Querying a Table, Sorting Rows
and locales, Benefits
outer join, Joined Tables
overlay, String Functions and Operators
owner, Privileges

P

Package
body, Creating the Package Body
specification, Creating the Package Specification
Packages, Introduction, Packages Report
Advantages, Advantages
Components, Package Components
dropping, Dropping A Package
referencing, Referencing a Package
User Defined Types, Using Packages With User Defined Types
Parameter Grid Window, Parameter Grid Window
partitioning, Partitioning
password, Role Attributes
authentication, Password authentication
of the superuser, Creating a Database Cluster
password file, The Password File
password_encryption configuration parameter, Security and Authentication
path
for schemas, Statement Behavior
pattern matching, Pattern Matching
performance, Performance Tips, Setting the Database Server for Optimal Performance
permission
see privilege
PGcancel, Cancelling Queries in Progress
PGCLIENTENCODING, Environment Variables
PGconn, Database Connection Control Functions
PGCONNECT_TIMEOUT, Environment Variables
PGDATA, Creating a Database Cluster
PGDATABASE, Environment Variables
PGDATESTYLE, Environment Variables
PGGEQO, Environment Variables
PGHOST, Environment Variables
PGHOSTADDR, Environment Variables
PGKRBSRVNAME, Environment Variables
PGLOCALEDIR, Environment Variables
PGOPTIONS, Environment Variables
PGPASSFILE, Environment Variables
PGPASSWORD, Environment Variables
PGPORT, Environment Variables
PGREALM, Environment Variables
PGREQUIRESSL, Environment Variables
PGresult, Main Functions
PGSERVICE, Environment Variables
PGSSLMODE, Environment Variables
PGSYSCONFDIR, Environment Variables
PGTZ, Environment Variables
PGUSER, Environment Variables
pg_aggregate, pg_aggregate
pg_am, pg_am
pg_amop, pg_amop
pg_amproc, pg_amproc
pg_attrdef, pg_attrdef
pg_attribute, pg_attribute
pg_authid, pg_authid
pg_auth_members, pg_auth_members
pg_autovacuum, pg_autovacuum
pg_cancel_backend, System Administration Functions
pg_cast, pg_cast
pg_class, pg_class
pg_client_encoding, String Functions and Operators
pg_config, pg_config
pg_constraint, pg_constraint
pg_controldata, Description
pg_conversion, pg_conversion
pg_ctl, Starting the Database Server, Description
pg_database, Template Databases, pg_database
pg_depend, pg_depend
pg_description, pg_description
pg_dump, Description
pg_dumpall, Description
pg_get_constraintdef, System Information Functions
pg_get_expr, System Information Functions
pg_get_indexdef, System Information Functions
pg_get_ruledef, System Information Functions
pg_get_serial_sequence, System Information Functions
pg_get_triggerdef, System Information Functions
pg_get_userbyid, System Information Functions
pg_get_viewdef, System Information Functions
pg_group, pg_group
pg_hba.conf, The pg_hba.conf file
pg_ident.conf, Ident Maps
pg_index, pg_index
pg_indexes, pg_indexes
pg_inherits, pg_inherits
pg_language, pg_language
pg_largeobject, pg_largeobject
pg_listener, pg_listener
pg_locks, pg_locks
pg_namespace, pg_namespace
pg_opclass, pg_opclass
pg_operator, pg_operator
pg_pltemplate, pg_pltemplate
pg_prepared_xacts, pg_prepared_xacts
pg_proc, pg_proc
pg_resetxlog, Description
pg_restore, Description
pg_rewrite, pg_rewrite
pg_roles, pg_roles
pg_rules, pg_rules
pg_service.conf, The Connection Service File
pg_settings, pg_settings
pg_shadow, pg_shadow
pg_shdepend, pg_shdepend
pg_start_backup, System Administration Functions
pg_statistic, Statistics Used by the Planner, pg_statistic
pg_stats, Statistics Used by the Planner, pg_stats
pg_stop_backup, System Administration Functions
pg_synonym, pg_synonym
pg_tables, pg_tables
pg_tablespace, pg_tablespace
pg_tablespace_databases, System Information Functions
pg_trigger, pg_trigger
pg_type, pg_type
pg_user, pg_user
pg_views, pg_views
phantom read, Transaction Isolation
PID
determining PID of server process
in libpq, Connection Status Functions
PITR, Backup and Restore
PL Debugger, EnterpriseDB PL Debugger
see also EnterpriseDB PL Debugger
point-in-time recovery, Backup and Restore
port, Database Connection Control Functions
port configuration parameter, Connection Settings
position, String Functions and Operators
PostgreSQL Error Codes, EnterpriseDB Error Codes
postgresql.conf, Run-time Configuration
power, Mathematical Functions and Operators
PQbackendPID, Connection Status Functions
PQbinaryTuples, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQcancel, Cancelling Queries in Progress
PQclear, Main Functions
PQcmdStatus, Retrieving Result Information for Other Commands
PQcmdTuples, Retrieving Result Information for Other Commands
PQconndefaults, Database Connection Control Functions
PQconnectdb, Database Connection Control Functions
PQconnectPoll, Database Connection Control Functions
PQconnectStart, Database Connection Control Functions
PQconsumeInput, Asynchronous Command Processing
PQdb, Connection Status Functions
PQendcopy, Obsolete Functions for COPY
PQerrorMessage, Connection Status Functions
PQescapeBytea, Escaping Binary Strings for Inclusion in SQL Commands
PQescapeByteaConn, Escaping Binary Strings for Inclusion in SQL Commands
PQescapeString, Escaping Strings for Inclusion in SQL Commands
PQescapeStringConn, Escaping Strings for Inclusion in SQL Commands
PQexec, Main Functions
PQexecParams, Main Functions
PQexecPrepared, Main Functions
PQfformat, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQfinish, Database Connection Control Functions
PQflush, Asynchronous Command Processing
PQfmod, Retrieving Query Result Information
PQfn, The Fast-Path Interface
PQfname, Retrieving Query Result Information
PQfnumber, Retrieving Query Result Information
PQfreeCancel, Cancelling Queries in Progress
PQfreemem, Escaping Binary Strings for Inclusion in SQL Commands
PQfsize, Retrieving Query Result Information
PQftable, Retrieving Query Result Information
PQftablecol, Retrieving Query Result Information
PQftype, Retrieving Query Result Information
PQgetCancel, Cancelling Queries in Progress
PQgetCopyData, Functions for Receiving COPY Data
PQgetisnull, Retrieving Query Result Information
PQgetlength, Retrieving Query Result Information
PQgetline, Obsolete Functions for COPY
PQgetlineAsync, Obsolete Functions for COPY
PQgetResult, Asynchronous Command Processing
PQgetssl, Connection Status Functions
PQgetvalue, Retrieving Query Result Information
PQhost, Connection Status Functions
PQisBusy, Asynchronous Command Processing
PQisnonblocking, Asynchronous Command Processing
PQmakeEmptyPGresult, Main Functions
PQnfields, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQntuples, Retrieving Query Result Information
PQoidStatus, Retrieving Result Information for Other Commands
PQoidValue, Retrieving Result Information for Other Commands
PQoptions, Connection Status Functions
PQparameterStatus, Connection Status Functions
PQpass, Connection Status Functions
PQport, Connection Status Functions
PQprepare, Main Functions
PQprint, Retrieving Query Result Information
PQputCopyData, Functions for Sending COPY Data
PQputCopyEnd, Functions for Sending COPY Data
PQputline, Obsolete Functions for COPY
PQputnbytes, Obsolete Functions for COPY
PQrequestCancel, Cancelling Queries in Progress
PQreset, Database Connection Control Functions
PQresetPoll, Database Connection Control Functions
PQresetStart, Database Connection Control Functions
PQresStatus, Main Functions
PQresultErrorField, Main Functions
PQresultErrorMessage, Main Functions
PQresultStatus, Main Functions
PQsendPrepare, Asynchronous Command Processing
PQsendQuery, Asynchronous Command Processing
PQsendQueryParams, Asynchronous Command Processing
PQsendQueryPrepared, Asynchronous Command Processing
PQserverVersion, Connection Status Functions
PQsetdb, Database Connection Control Functions
PQsetdbLogin, Database Connection Control Functions
PQsetErrorVerbosity, Control Functions
PQsetnonblocking, Asynchronous Command Processing
PQsetNoticeProcessor, Notice Processing
PQsetNoticeReceiver, Notice Processing
PQsocket, Connection Status Functions
PQstatus, Connection Status Functions
PQtrace, Control Functions
PQtransactionStatus, Connection Status Functions
PQtty, Connection Status Functions
PQunescapeBytea, Escaping Binary Strings for Inclusion in SQL Commands
PQuntrace, Control Functions
PQuser, Connection Status Functions
predicate locking, Serializable Isolation versus True Serializability
preload_libraries configuration parameter, Kernel Resource Usage
PREPARE, Description
PREPARE TRANSACTION, Description
prepared statements
creating, Description
executing, Description
removing, DEALLOCATE
showing the query plan, Description
primary key, Primary Keys
privilege, Privileges, Privileges
querying, System Information Functions
with rules, Rules and Privileges
for schemas, Schemas and Privileges
with views, Rules and Privileges
procedures, Procedures Report
Program Body Frame, Program Body Frame

Q

qualified name, Creating a Schema
query, Querying a Table, Queries
query executor, iQuery
query plan, Using EXPLAIN
Query Profiler, Query Profiler
query tree, The Query Tree
quotation marks
and identifiers, Identifiers and Key Words
escaping, String Constants
quote_ident, String Functions and Operators
quote_literal, String Functions and Operators

R

R-tree
see index
radians, Mathematical Functions and Operators
random, Mathematical Functions and Operators
random_page_cost configuration parameter, Planner Cost Constants
range table, The Query Tree
raw, Binary Data
RDO
Using ADO with ODBC, Using ADO with ODBC
read-only transaction, Statement Behavior
read/write activity, Database Read/Write Activity Report
real, Floating-Point Types
redirect_stderr configuration parameter, Where to log
ref cursor
in SPL, REF CURSORS and Cursor Variables
weakly typed, REF CURSORS and Cursor Variables
referential integrity, Foreign Keys, Foreign Keys
regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions
see also pattern matching
reindex, Routine Reindexing, Description
reindexdb, Description
relation, Concepts
relational database, Concepts
RELEASE SAVEPOINT, Description
repeat, String Functions and Operators
replace, String Functions and Operators
replication, EnterpriseDB Replication
RESET, Description
RESTRICT
with DROP, Dependency Tracking
foreign key action, Foreign Keys
REVOKE, Privileges, REVOKE
right join, Joined Tables
role, Database Roles
membership in, Role Membership
privilege to create, Role Attributes
ROLLBACK, Description
ROLLBACK PREPARED, Description
ROLLBACK TO SAVEPOINT, Description
round, Mathematical Functions and Operators
row, Concepts, Table Basics
rowid
data types, Integer Types
rpad, String Functions and Operators
rtrim, String Functions and Operators
rule, The Rule System
and views, Views and the Rule System
for DELETE, Rules on INSERT, UPDATE, and DELETE
for INSERT, Rules on INSERT, UPDATE, and DELETE
for SELECT, How SELECT Rules Work
compared with triggers, Rules versus Triggers
for UPDATE, Rules on INSERT, UPDATE, and DELETE
run, EnterpriseDB PSQL

S

sample database, Sample Database
sample script, Sample Database
SAVEPOINT, Description
savepoints
defining, Description
releasing, Description
rolling back, Description
scalar
see expression
schema, Schemas, Overview
creating, Creating a Schema
current, The Schema Search Path, System Information Functions
public, The Public Schema
removing, Creating a Schema
SCO OpenServer
IPC configuration, Shared Memory and Semaphores
search path, The Schema Search Path
current, System Information Functions
search_path, The Schema Search Path
search_path configuration parameter, Statement Behavior
SELECT, Querying a Table, Queries, Description
select list, Select Lists
SELECT INTO, Description
in SPL, SELECT INTO
semaphores, Shared Memory and Semaphores
sequence, Sequence Manipulation Functions
sequences, Sequences Report
sequential scan, Planner Method Configuration
serializability, Serializable Isolation versus True Serializability
server log, Error Reporting and Logging
log file maintenance, Log File Maintenance
server_encoding configuration parameter, Preset Options
server_version configuration parameter, Preset Options
SET, System Administration Functions, Description
SET CONSTRAINTS, Description
set difference, Combining Queries
set intersection, Combining Queries
set operation, Combining Queries
set returning functions
functions, Set Returning Functions
SET ROLE, Description
SET SESSION AUTHORIZATION, Description
SET TRANSACTION, Description
set union, Combining Queries
setseed, Mathematical Functions and Operators
settings, Show Settings Report
setval, Sequence Manipulation Functions
set_bit, Binary String Functions and Operators
set_byte, Binary String Functions and Operators
shared memory, Shared Memory and Semaphores
shared_buffers configuration parameter, Memory
SHMMAX, Shared Memory and Semaphores
SHOW, System Administration Functions, Description
shutdown, Shutting Down the Server
SIGHUP, Run-time Configuration, The pg_hba.conf file, Ident Maps
SIGINT, Shutting Down the Server
sign, Mathematical Functions and Operators
signal
backend processes, System Administration Functions
significant digits, Locale and Formatting
SIGQUIT, Shutting Down the Server
SIGTERM, Shutting Down the Server
silent_mode configuration parameter, When To Log
SIMILAR TO, SIMILAR TO Regular Expressions
smalldatetime, Date/Time Types
smallfloat, Floating-Point Types
smallint, Integer Types
smallmoney, Arbitrary Precision Numbers
Solaris
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
SOME, Aggregate Functions, Subquery Expressions
sorting, Sorting Rows
SPL, Programming in SPL
DELETE RETURNING, Programming in SPL
INSERT RETURNING, Programming in SPL
RETURN Statement in SPL Procedures, Programming in SPL
UPDATE RETURNING, Programming in SPL
split_part, String Functions and Operators
SQL Interactive, Using SQL Interactive
sqrt, Mathematical Functions and Operators
ssh, Secure TCP/IP Connections with SSH Tunnels
SSL
in libpq, Connection Status Functions
ssl configuration parameter, Security and Authentication
standard deviation, Aggregate Functions
START TRANSACTION, Description
statement_timeout configuration parameter, Statement Behavior
statistics, The Statistics Collector
of the planner, Statistics Used by the Planner, Updating planner statistics
stats_block_level configuration parameter, Query and Index Statistics Collector
stats_command_string configuration parameter, Query and Index Statistics Collector
stats_reset_on_server_start configuration parameter, Query and Index Statistics Collector
stats_row_level configuration parameter, Query and Index Statistics Collector
stats_start_collector configuration parameter, Query and Index Statistics Collector
Step Into, Stepping Through the Code
Step Over, Stepping Through the Code
string
see character string
string concatenation , String Functions and Operators
strings
escape, Version and Platform Compatibility
strpos, String Functions and Operators
subquery, Aggregate Functions, Scalar Subqueries, Subqueries, Subquery Expressions
substr, String Functions and Operators
substring, String Functions and Operators, Binary String Functions and Operators, SIMILAR TO Regular Expressions
sum, Aggregate Functions
superuser, Role Attributes
superuser_reserved_connections configuration parameter, Connection Settings
syntax
SQL, Lexical Structure
syslog_facility configuration parameter, Where to log
syslog_identity configuration parameter, Where to log
system catalogs, System Catalogs
SYS_REFCURSOR, REF CURSORS and Cursor Variables

T

table, Concepts, Table Basics
creating, Table Basics
inheritance, Inheritance
modifying, Modifying Tables
partitioning, Partitioning
removing, Table Basics
renaming, Renaming a Table
table expression, Table Expressions
table information, Tables Report
table io, Table IO Detail Report
tablespace, Tablespaces
default, Statement Behavior
target list, The Query Tree
tcp_keepalives_count configuration parameter, Connection Settings
tcp_keepalives_idle configuration parameter, Connection Settings
tcp_keepalives_interval configuration parameter, Connection Settings
template0, Template Databases
template1, Creating a Database, Template Databases
temp_buffers configuration parameter, Memory
test, EnterpriseDB PL Debugger
text, Character Types
threads
with libpq, Behavior in Threaded Programs
time, Times
constants, Special Values
current, Current Date/Time
output format, Date/Time Output
see also formatting
time zone, Locale and Formatting
Australian, Locale and Formatting
timelines, Backup and Restore
timeout
client authentication, Security and Authentication
deadlock, Lock Management
timestamp, Date/Time Types, Time Stamps
timezone configuration parameter, Locale and Formatting
tinyint
see smallint
tinytext, Character Types
TOAST
per-column storage settings, Description
token, Lexical Structure
to_ascii, String Functions and Operators
to_char, Data Type Formatting Functions
to_hex, String Functions and Operators
transaction, Transactions
transaction ID
wraparound, Preventing transaction ID wraparound failures
transaction isolation, Transaction Isolation
transaction isolation level, Transaction Isolation, Statement Behavior
read committed, Read Committed Isolation Level
serializable, Serializable Isolation Level
transaction log
see WAL
translate, String Functions and Operators
trigger, Triggers
compared with rules, Rules versus Triggers
triggers, Triggers Report
trim, String Functions and Operators
true, Boolean Type
trunc, Mathematical Functions and Operators
date, TRUNC
TRUNCATE, Description
type
see data type

U

UNION, Combining Queries
unique constraint, Unique Constraints
Unix domain socket, Database Connection Control Functions
UnixWare
IPC configuration, Shared Memory and Semaphores
unix_socket_directory configuration parameter, Connection Settings
unix_socket_group configuration parameter, Connection Settings
unix_socket_permissions configuration parameter, Connection Settings
unqualified name, The Schema Search Path
UPDATE, Updates, Updating Data, Description
in SPL, UPDATE
updating, Updating Data
upgrading, Migration Between Releases
upper, String Functions and Operators
user, Database Roles
current, System Information Functions
user activity, User Activity Report
Using ADO with ODBC, Using ADO with ODBC
Using REF CURSOR in a .NET Application, Using REF CURSOR in a .NET Application
Using REF CURSORS with Java, Using REF CURSORS with Java

V

vacuum, Routine Vacuuming, Description
vacuumdb, Description
vacuum_cost_delay configuration parameter, Cost-Based Vacuum Delay
vacuum_cost_limit configuration parameter, Cost-Based Vacuum Delay
vacuum_cost_page_dirty configuration parameter, Cost-Based Vacuum Delay
vacuum_cost_page_hit configuration parameter, Cost-Based Vacuum Delay
vacuum_cost_page_miss configuration parameter, Cost-Based Vacuum Delay
value expression, Value Expressions
varbinary, Binary Data
varchar, Character Types
varchar2
see varchar
Variable View Frame, Variable View Frame
variance, Aggregate Functions
version, System Information Functions
compatibility, Migration Between Releases
view, Views
implementation through rules, Views and the Rule System
updating, Cooperation with Views
View Audit Logs, View Audit Logs
views, Views Report
Visual Explain, Visual Explain

W

WAL, Write-Ahead Logging (WAL)
wal_buffers configuration parameter, Settings
wal_sync_method configuration parameter, Settings
WHERE, The WHERE Clause
where to log, Where to log
width_bucket, Mathematical Functions and Operators
work_mem configuration parameter, Memory

X

XMAX
column, System Columns
XMIN
column, System Columns
 
 ©2004-2007 EnterpriseDB All Rights Reserved