The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference by The PostgreSQL Global Development Group Paperback (6"x9"), 454 pages ISBN 9781906966041 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>>

PostgreSQL 9.0 Reference Manual Volume 1A Buy the book here! >>> learn more

E Acronyms

This is a list of acronyms commonly used in the PostgreSQL documentation and in discussions about PostgreSQL.

ANSI

American National Standards Institute

API

Application Programming Interface

ASCII

American Standard Code for Information Interchange

BKI

Backend Interface (BKI Backend Interface)

CA

Certificate Authority

CIDR

Classless Inter-Domain Routing

CPAN

Comprehensive Perl Archive Network

CRL

Certificate Revocation List

CSV

Comma Separated Values

CVE

Common Vulnerabilities and Exposures

DBA

Database Administrator

DBI

Database Interface (Perl)

DBMS

Database Management System

DDL

Data Definition Language, SQL commands such as CREATE TABLE, ALTER USER

DML

Data Manipulation Language, SQL commands such as INSERT, UPDATE, DELETE

DST

Daylight Saving Time

ECPG

Embedded C for PostgreSQL (see Volume 2: ECPG - Embedded SQL in C)

ESQL

Embedded SQL

FAQ

Frequently Asked Questions

FSM

Free Space Map (Free Space Map)

GEQO

Genetic Query Optimizer (Genetic Query Optimizer [1])

GIN

Generalized Inverted Index (GIN Indexes)

GiST

Generalized Search Tree (GiST Indexes)

Git

Git

GMT

Greenwich Mean Time

GSSAPI

Generic Security Services Application Programming Interface

GUC

Grand Unified Configuration (see Volume 3: Setting Parameters), the PostgreSQL subsystem that handles server configuration

HBA

Host-Based Authentication (see Volume 3: The pg_hba.conf file)

HOT

Heap-Only Tuples

IEC

International Electrotechnical Commission

IEEE

Institute of Electrical and Electronics Engineers

IPC

Inter-Process Communication

ISO

International Organization for Standardization

ISSN

International Standard Serial Number

JDBC

Java Database Connectivity

LDAP

Lightweight Directory Access Protocol

MSVC

Microsoft Visual C

MVCC

Multi-Version Concurrency Control (see section 11 Concurrency Control)

NLS

National Language Support

ODBC

Open Database Connectivity

OID

Object Identifier (see section 6.16 Object Identifier Types)

OLAP

Online Analytical Processing

OLTP

Online Transaction Processing

ORDBMS

Object-Relational Database Management System

PAM

Pluggable Authentication Modules

PGSQL

PostgreSQL

PGXS

PostgreSQL Extension System (see Volume 2: Extension Building Infrastructure)

PID

Process Identifier

PITR

Point-In-Time Recovery (see Volume 3: Continuous Archiving and Point-In-Time Recovery (PITR)) (Continuous Archiving)

PL

Programming Languages (server-side) (see Volume 2: Server Programming)

POSIX

Portable Operating System Interface

RDBMS

Relational Database Management System

RFC

Request For Comments

SGML

Standard Generalized Markup Language

SPI

Server Programming Interface (see Volume 2: Server Programming Interface)

SQL

Structured Query Language

SRF

Set-Returning Function (see Volume 2: Returning Sets)

SSH

Secure Shell

SSL

Secure Sockets Layer

SSPI

Security Support Provider Interface

SYSV

Unix System V

TCP/IP

Transmission Control Protocol (TCP) / Internet Protocol (IP)

TID

Tuple Identifier (see section 6.16 Object Identifier Types)

TOAST

The Oversized-Attribute Storage Technique (TOAST)

TPC

Transaction Processing Performance Council

URL

Uniform Resource Locator

UTC

Coordinated Universal Time

UTF

Unicode Transformation Format

UTF8

Eight-Bit Unicode Transformation Format

UUID

Universally Unique Identifier (see section 6.12 UUID Type)

WAL

Write-Ahead Log (see Volume 3: Reliability and the Write-Ahead Log)

XID

Transaction Identifier (see section 6.16 Object Identifier Types)

XML

Extensible Markup Language