Acronyms
This is a list of acronyms commonly used in the PostgreSQL
documentation and in discussions about PostgreSQL.
ANSI
American National Standards InstituteAPIApplication Programming InterfaceASCIIAmerican Standard
Code for Information InterchangeBKI
Backend Interface
CACertificate AuthorityCIDRClassless
Inter-Domain RoutingCPANComprehensive Perl Archive NetworkCRLCertificate
Revocation ListCSVComma
Separated ValuesCTE
Common Table Expression
CVECommon Vulnerabilities and ExposuresDBADatabase
AdministratorDBIDatabase Interface (Perl)DBMSDatabase Management
SystemDDLData
Definition Language, SQL commands such as CREATE
TABLE, ALTER USERDMLData
Manipulation Language, SQL commands such as INSERT,
UPDATE, DELETEDSTDaylight
Saving TimeECPG
Embedded C for PostgreSQL
ESQLEmbedded
SQLFAQFrequently Asked
QuestionsFSM
Free Space Map
GEQO
Genetic Query Optimizer
GIN
Generalized Inverted Index
GiST
Generalized Search Tree
GitGitGMTGreenwich Mean TimeGSSAPIGeneric
Security Services Application Programming InterfaceGUC
Grand Unified Configuration,
the PostgreSQL subsystem that handles server configuration
HBA
Host-Based Authentication
HOT
Heap-Only Tuples
IECInternational
Electrotechnical CommissionIEEEInstitute of Electrical and
Electronics EngineersIPCInter-Process
CommunicationISOInternational Organization for
StandardizationISSNInternational Standard
Serial NumberJDBCJava
Database ConnectivityJITJust-in-Time
compilationJSONJavaScript Object NotationLDAPLightweight
Directory Access ProtocolLSN
Log Sequence Number, see pg_lsn
and WAL Internals.
MITM
Man-in-the-middle attackMSVCMicrosoft
Visual CMVCC
Multi-Version Concurrency Control
NLSNational
Language SupportODBCOpen
Database ConnectivityOID
Object Identifier
OLAPOnline Analytical
ProcessingOLTPOnline Transaction
ProcessingORDBMSObject-Relational
Database Management SystemPAMPluggable
Authentication ModulesPGSQLPostgreSQLPGXSPostgreSQL Extension System
PIDProcess IdentifierPITR
Point-In-Time
Recovery (Continuous Archiving)
PL
Procedural Languages (server-side)
POSIXPortable Operating
System InterfaceRDBMSRelational
Database Management SystemRFCRequest For
CommentsSGMLStandard Generalized
Markup LanguageSNI
Server Name Indication,
RFC 6066SPI
Server Programming Interface
SP-GiST
Space-Partitioned Generalized Search Tree
SQLStructured Query LanguageSRF
Set-Returning Function
SSHSecure
ShellSSLSecure Sockets LayerSSPISecurity
Support Provider InterfaceSYSVUnix System VTCP/IPTransmission
Control Protocol (TCP) / Internet Protocol (IP)TID
Tuple Identifier
TLS
Transport Layer SecurityTOAST
The Oversized-Attribute Storage Technique
TPCTransaction Processing
Performance CouncilURLUniform Resource
LocatorUTCCoordinated
Universal TimeUTFUnicode Transformation
FormatUTF8Eight-Bit Unicode
Transformation FormatUUID
Universally Unique Identifier
WAL
Write-Ahead Log
XID
Transaction Identifier
XMLExtensible Markup
Language