| Index- 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-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,
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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-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
- 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
- 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
- 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
- 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
| |
---|