PrevFast Backward  

Index

Symbols

*, Select-List Items
.net, EDB Connector/.NET

A

aggregate function, Aggregate Functions
built-in, Aggregate Functions
invocation, Aggregate Expressions
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, ALTER DATABASE
ALTER FUNCTION, ALTER FUNCTION
ALTER GROUP, ALTER GROUP
ALTER INDEX, ALTER INDEX
ALTER OPERATOR, ALTER OPERATOR
ALTER SCHEMA, ALTER SCHEMA
ALTER SEQUENCE, ALTER SEQUENCE
ALTER TABLE, ALTER TABLE
ALTER TABLESPACE, ALTER TABLESPACE
ALTER TRIGGER, ALTER TRIGGER
ALTER TYPE, ALTER TYPE
ALTER USER, User Attributes, ALTER USER
ANALYZE, Updating planner statistics, ANALYZE
AND (operator), Logical Operators
ANY, Aggregate Functions, Subquery Expressions
archive_command configuration parameter, Archiving
australian_timezones configuration parameter, Locale and Formatting
authentication_timeout configuration parameter, Security and Authentication
autocommit
bulk-loading data, Disable Autocommit
EDB-PSQL+, Variables
average, Aggregate Functions, Aggregate Functions

B

B-tree
see index
backup, System Administration Functions, Backup and Restore
BEGIN, BEGIN
BETWEEN, Comparison Operators
bgwriter_delay configuration parameter, Background Writer
bgwriter_maxpages configuration parameter, Background Writer
bgwriter_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
bit_and, Aggregate Functions
bit_or, Aggregate Functions
blob
see binary large object
block_size configuration parameter, Preset Options
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
BSD/OS
IPC configuration, Shared Memory and Semaphores
byte
data types, Binary Data
bytea, Binary Data

C

CallableStatement, EDB Connector/Java
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
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
check constraint, Check Constraints
checkpoint, WAL Configuration, CHECKPOINT
checkpoint_segments configuration parameter, Checkpoints
checkpoint_timeout configuration parameter, Checkpoints
checkpoint_warning configuration parameter, Checkpoints
check_function_bodies configuration parameter, Statement Behavior
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, CLOSE
CLUSTER, CLUSTER
of databases
see database cluster
clusterdb, clusterdb
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 reference, Column References
col_description, System Information Functions
COMMENT, COMMENT
about database objects, System Information Functions
in SQL, Comments
COMMIT, COMMIT
commit_delay configuration parameter, Settings
commit_siblings configuration parameter, Settings
comparison
operators, Comparison Operators
subquery result row, Subquery Expressions
concurrency, Concurrency Control
conditional expression, Conditional Expressions
configuration
of the server, Run-time Configuration
of the server
functions, System Administration Functions
config_file configuration parameter, File Locations
conjunction, Logical Operators
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
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, CREATE DATABASE
CREATE FUNCTION, CREATE FUNCTION
CREATE GROUP, CREATE GROUP
CREATE INDEX, CREATE INDEX
CREATE OPERATOR, CREATE OPERATOR
CREATE PROCEDURE, CREATE PROCEDURE
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 TABLESPACE, Tablespaces, CREATE TABLESPACE
CREATE TRIGGER, CREATE TRIGGER
CREATE TYPE, CREATE TYPE
CREATE USER, Database Users, CREATE USER
CREATE VIEW, CREATE VIEW
createdb, Creating a Database, createdb
createuser, Database Users, createuser
crypt, Password authentication
CTID
column, System Columns
currval, Sequence Manipulation Functions
cursor
CLOSE, CLOSE
DECLARE, DECLARE
FETCH, FETCH
in EDB-SPL, Static Cursors
showing the query plan, EXPLAIN

D

data area
see database cluster
data type, Data Types
conversion, Type Conversion
numeric, Numeric Types
database, Managing Databases
privilege to create, User Attributes
database activity
monitoring, Monitoring Database Activity
database cluster, Concepts, Creating a Database Cluster
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
DateStyle configuration parameter, Locale and Formatting
datetime, Date/Time Types
db_user_namespace configuration parameter, Security and Authentication
deadlock, Deadlocks
timeout during, Lock Management
deadlock_timeout configuration parameter, Lock Management
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, DECLARE
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
DELETE, Deletions, Deleting Data, DELETE
in EDB-SPL, DELETE
deleting, Deleting Data
desc, EDB-PSQL+
describe, EDB-PSQL+
dirty read, Transaction Isolation
disjunction, Logical Operators
disk drive, Internals
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, DROP DATABASE
DROP FUNCTION, DROP FUNCTION
DROP GROUP, DROP GROUP
DROP INDEX, DROP INDEX
DROP OPERATOR, DROP OPERATOR
DROP PROCEDURE, DROP PROCEDURE
DROP RULE, DROP RULE
DROP SCHEMA, DROP SCHEMA
DROP SEQUENCE, DROP SEQUENCE
DROP TABLE, Creating a New Table, DROP TABLE
DROP TABLESPACE, DROP TABLESPACE
DROP TRIGGER, DROP TRIGGER
DROP TYPE, DROP TYPE
DROP USER, Database Users, DROP USER
DROP VIEW, DROP VIEW
dropdb, Destroying a Database, dropdb
dropuser, Database Users, dropuser
duplicate, Querying a Table
duplicates, DISTINCT
dynamic loading, Other Defaults
dynamic_library_path configuration parameter, Other Defaults

E

EDB-POSTGRES (the program), edb-postgres
EDB-Postgres catalogs, System Catalogs
edb-postmaster, Starting the Database Server, edb-postmaster
edb-psql, edb-psql
edb-psql+, EDB-PSQL+
EDB-Replicationc, EDB-Replication
EDB-SPL, Programming in EDB-SPL
effective_cache_size configuration parameter, Planner Cost Constants
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
END, END
enterprisedb user, The enterprisedb User Account
every, Aggregate Functions
EXCEPT, Combining Queries
EXISTS, Subquery Expressions
EXPLAIN, Using EXPLAIN, EXPLAIN
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
FETCH, FETCH
float
see floating point
floating point, Floating-Point Types
floating-point
display, Locale and Formatting
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
function, Functions and Operators

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
GRANT, Privileges, GRANT
group, Groups
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
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
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 scan, Planner Method Configuration
initdb, Creating a Database Cluster, initdb
INSERT, Populating a Table With Rows, Inserting Data, INSERT
in EDB-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
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

J

jdbc driver types, EDB Connector/Java
jdbc versions, EDB Connector/Java
join, Joins Between Tables, Joined Tables
controlling the order, Controlling the Planner with Explicit JOIN Clauses
left, Joined Tables
natural, Joined Tables
outer, Joins Between Tables, Joined Tables
right, Joined Tables
self, Joins Between Tables
join_collapse_limit configuration parameter, Other Planner Options

K

Kerberos, Kerberos authentication
key word
syntax of, Identifiers and Key Words
km , Comparison Operators
krb_server_keyfile 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
left join, Joined Tables
length
of a binary string
see binary strings, length
of a character string
see character strings, length
LIKE, LIKE
LIMIT, LIMIT and OFFSET
Linux
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
list, EDB-PSQL+
listen_addresses configuration parameter, Connection Settings
locale, Creating a Database Cluster, Locale Support
lock, Explicit Locking, Table-Level Locks, LOCK
monitoring, Viewing Locks
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 EDB-SPL, Loops
lvarchar, Character Types

M

MacOS X
IPC configuration, Shared Memory and Semaphores
maintenance, Routine Database Maintenance Tasks
maintenance_work_mem configuration parameter, Memory
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_stack_depth configuration parameter, Memory
MD5, Password authentication
mediumtext, Character Types
min, Aggregate Functions
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
nonrepeatable read, Transaction Isolation
NOT (operator), Logical Operators
NOT IN, Subquery Expressions
not-null constraint, Not-Null Constraints
null value
with check constraints, Check Constraints
comparing, Comparison Operators
default value, Default Values
in DISTINCT, DISTINCT
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
odbc, EDB Connector/ODBC
OFFSET, LIMIT and OFFSET
OID
column, System Columns
on-line backup, Backup and Restore
OpenBSD
IPC configuration, Shared Memory and Semaphores
start script, Starting the Database Server
operator, Functions and Operators
invocation, Operator Invocations
logical, Logical Operators
precedence, Lexical Precedence
syntax, Operators
operator class, Operator Classes
OR (operator), Logical Operators
ORDER BY, Querying a Table, Sorting Rows
and locales, Benefits
outer join, Joined Tables
overlay, String Functions and Operators
owner, Privileges

P

password, User Attributes
authentication, Password authentication
of the superuser, Creating a Database Cluster
password_encryption configuration parameter, Security and Authentication
path
for schemas, Statement Behavior
pattern matching, Pattern Matching
performance, Performance Tips
permission
see privilege
PGDATA, Creating a Database Cluster
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_cancel_backend, System Administration Functions
pg_cast, pg_cast
pg_class, pg_class
pg_config, pg_config
pg_constraint, pg_constraint
pg_controldata, pg_controldata
pg_conversion, pg_conversion
pg_ctl, Starting the Database Server, pg_ctl
pg_database, Template Databases, pg_database
pg_depend, pg_depend
pg_description, pg_description
pg_dump, pg_dump
pg_dumpall, pg_dumpall
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_proc, pg_proc
pg_restore, pg_restore
pg_rewrite, pg_rewrite
pg_rules, pg_rules
pg_settings, pg_settings
pg_shadow, pg_shadow
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_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
PITR, Backup and Restore
point-in-time recovery, Backup and Restore
port configuration parameter, Connection Settings
postgresql.conf, Run-time Configuration
predicate locking, Serializable Isolation versus True Serializability
preload_libraries configuration parameter, Kernel Resource Usage
PREPARE, PREPARE
prepared statements
creating, PREPARE
showing the query plan, EXPLAIN
preparedstatement, EDB Connector/Java
primary key, Primary Keys
privilege, Privileges, Privileges
querying, System Information Functions
for schemas, Schemas and Privileges
ps
to monitor activity, Standard Unix Tools

Q

qualified name, Creating a Schema
query, Querying a Table, Queries
query plan, Using EXPLAIN
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
random_page_cost configuration parameter, Planner Cost Constants
raw, Binary Data
read-only transaction, Statement Behavior
real, Floating-Point Types
redirect_stderr configuration parameter, Where to log
referential integrity, Foreign Keys, Foreign Keys
regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions
see also pattern matching
reindex, Routine Reindexing, REINDEX
relation, Concepts
relational database, Concepts
RELEASE SAVEPOINT, RELEASE SAVEPOINT
rendezvous_name configuration parameter, Connection Settings
replication, EDB-Replication
RESTRICT
with DROP, Dependency Tracking
foreign key action, Foreign Keys
resultset, EDB Connector/Java
REVOKE, Privileges, REVOKE
right join, Joined Tables
ROLLBACK, ROLLBACK
ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT
row, Concepts, Table Basics
ROWID
column, System Columns
data types, Integer Types
run, EDB-PSQL+

S

sample database, Sample Database
sample script, Sample Database
SAVEPOINT, SAVEPOINT
savepoints
defining, SAVEPOINT
releasing, RELEASE SAVEPOINT
rolling back, ROLLBACK TO SAVEPOINT
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, SELECT
select list, Select Lists
SELECT INTO, SELECT INTO
in EDB-SPL, SELECT INTO
semaphores, Shared Memory and Semaphores
sequence, Sequence Manipulation Functions
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, SET
SET CONSTRAINTS, SET CONSTRAINTS
set difference, Combining Queries
set intersection, Combining Queries
set operation, Combining Queries
set returning functions
functions, Set Returning Functions
SET SESSION AUTHORIZATION, SET SESSION AUTHORIZATION
SET TRANSACTION, SET TRANSACTION
set union, Combining Queries
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
shutdown, Shutting Down the Server
SIGHUP, Run-time Configuration, The pg_hba.conf file, Ident Maps
SIGINT, Shutting Down the Server
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
ssh, Secure TCP/IP Connections with SSH Tunnels
standard deviation, Aggregate Functions
START TRANSACTION, START TRANSACTION
statement, EDB Connector/Java
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
stored procedures, EDB Connector/Java
string
see character string
subquery, Aggregate Functions, Scalar Subqueries, Subqueries, Subquery Expressions
substr, String Functions and Operators
substring, Binary String Functions and Operators, SIMILAR TO Regular Expressions
sum, Aggregate Functions
superuser, User Attributes
superuser_reserved_connections configuration parameter, Connection Settings
syntax
SQL, SQL Syntax
syslog_facility configuration parameter, Where to log
syslog_identity configuration parameter, Where to log
system catalogs, System Catalogs

T

table, Concepts, Table Basics
creating, Table Basics
modifying, Modifying Tables
removing, Table Basics
renaming, Renaming a Table
table expression, Table Expressions
tablespace, Tablespaces
default, Statement Behavior
template0, Template Databases
template1, Creating a Database, Template Databases
text, Character Types
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_char, Data Type Formatting Functions
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
trigger, Triggers
true, Boolean Type
trunc
date, TRUNC
TRUNCATE, TRUNCATE
type
see data type

U

UNION, Combining Queries
unique constraint, Unique Constraints
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, UPDATE
in EDB-SPL, UPDATE
RETURNING, UPDATE RETURNING
updating, Updating Data
user, Database Users
current, System Information Functions

V

vacuum, Routine Vacuuming, VACUUM
vacuumdb, vacuumdb
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
variance, Aggregate Functions
version, System Information Functions
view, Views

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
work_mem configuration parameter, Memory

X

XMAX
column, System Columns
XMIN
column, System Columns

Y

year, Arbitrary Precision Numbers
PrevHome 
System Catalogs