3 <appendix id=
"acronyms">
4 <title>Acronyms
</title>
7 This is a list of acronyms commonly used in the
<productname>PostgreSQL<
/>
8 documentation and in discussions about
<productname>PostgreSQL<
/>.
13 <term><acronym>ANSI
</acronym></term>
16 <ulink url=
"http://en.wikipedia.org/wiki/American_National_Standards_Institute">
17 American National Standards Institute
</ulink>
23 <term><acronym>API
</acronym></term>
26 <ulink url=
"http://en.wikipedia.org/wiki/API">Application Programming Interface
</ulink>
32 <term><acronym>ASCII
</acronym></term>
35 <ulink url=
"http://en.wikipedia.org/wiki/Ascii">American Standard
36 Code for Information Interchange
</ulink>
42 <term><acronym>BKI
</acronym></term>
45 <link linkend=
"bki">Backend Interface
</link>
51 <term><acronym>CA
</acronym></term>
54 <ulink url=
"http://en.wikipedia.org/wiki/Certificate_authority">Certificate Authority
</ulink>
60 <term><acronym>CIDR
</acronym></term>
64 url=
"http://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing">Classless
65 Inter-Domain Routing
</ulink>
71 <term><acronym>CPAN
</acronym></term>
74 <ulink url=
"http://www.cpan.org/">Comprehensive Perl Archive Network
</ulink>
80 <term><acronym>CRL
</acronym></term>
84 url=
"http://en.wikipedia.org/wiki/Certificate_revocation_list">Certificate
85 Revocation List
</ulink>
91 <term><acronym>CSV
</acronym></term>
95 url=
"http://en.wikipedia.org/wiki/Comma-separated_values">Comma
96 Separated Values
</ulink>
102 <term><acronym>CVE
</acronym></term>
105 <ulink url=
"http://cve.mitre.org/">Common Vulnerabilities and Exposures
</ulink>
111 <term><acronym>CVS
</acronym></term>
115 url=
"http://en.wikipedia.org/wiki/Concurrent_Versions_System">Concurrent
116 Versions System
</ulink>
122 <term><acronym>DBA
</acronym></term>
126 url=
"http://en.wikipedia.org/wiki/Database_administrator">Database
127 Administrator
</ulink>
133 <term><acronym>DBI
</acronym></term>
136 <ulink url=
"http://dbi.perl.org/">Database Interface (Perl)
</ulink>
142 <term><acronym>DBMS
</acronym></term>
145 <ulink url=
"http://en.wikipedia.org/wiki/Dbms">Database Management
152 <term><acronym>DDL
</acronym></term>
156 url=
"http://en.wikipedia.org/wiki/Data_Definition_Language">Data
157 Definition Language
</ulink>, SQL commands such as
<command>CREATE
158 TABLE<
/>,
<command>ALTER USER<
/>
164 <term><acronym>DML
</acronym></term>
168 url=
"http://en.wikipedia.org/wiki/Data_Manipulation_Language">Data
169 Manipulation Language
</ulink>, SQL commands such as
<command>INSERT<
/>,
170 <command>UPDATE<
/>,
<command>DELETE<
/>
176 <term><acronym>DST
</acronym></term>
180 url=
"http://en.wikipedia.org/wiki/Daylight_saving_time">Daylight
187 <term><acronym>ECPG
</acronym></term>
190 <link linkend=
"ecpg">Embedded C for PostgreSQL
</link>
196 <term><acronym>ESQL
</acronym></term>
199 <ulink url=
"http://en.wikipedia.org/wiki/Embedded_SQL">Embedded
206 <term><acronym>FAQ
</acronym></term>
209 <ulink url=
"http://en.wikipedia.org/wiki/FAQ">Frequently Asked
216 <term><acronym>FSM
</acronym></term>
219 <link linkend=
"storage-fsm">Free Space Map
</link>
225 <term><acronym>GEQO
</acronym></term>
228 <link linkend=
"geqo">Genetic Query Optimizer
</link>
234 <term><acronym>GIN
</acronym></term>
237 <link linkend=
"GIN">Generalized Inverted Index
</link>
243 <term><acronym>GiST
</acronym></term>
246 <link linkend=
"GiST">Generalized Search Tree
</link>
252 <term><acronym>GMT
</acronym></term>
255 <ulink url=
"http://en.wikipedia.org/wiki/GMT">Greenwich Mean Time
</ulink>
261 <term><acronym>GSSAPI
</acronym></term>
265 url=
"http://en.wikipedia.org/wiki/Generic_Security_Services_Application_Program_Interface">Generic
266 Security Services Application Programming Interface
</ulink>
272 <term><acronym>GUC
</acronym></term>
275 <link linkend=
"config-setting">Grand Unified Configuration
</link>,
276 the
<productname>PostgreSQL<
/> subsystem that handles server configuration
282 <term><acronym>HBA
</acronym></term>
285 <link linkend=
"auth-pg-hba-conf">Host-Based Authentication
</link>
291 <term><acronym>HOT
</acronym></term>
295 url=
"http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT">Heap-Only
302 <term><acronym>IEC
</acronym></term>
306 url=
"http://en.wikipedia.org/wiki/International_Electrotechnical_Commission">International
307 Electrotechnical Commission
</ulink>
313 <term><acronym>IEEE
</acronym></term>
316 <ulink url=
"http://standards.ieee.org/">Institute of Electrical and
317 Electronics Engineers
</ulink>
323 <term><acronym>IPC
</acronym></term>
327 url=
"http://en.wikipedia.org/wiki/Inter-process_communication">Inter-Process
328 Communication
</ulink>
334 <term><acronym>ISO
</acronym></term>
337 <ulink url=
"http://www.iso.org/iso/home.htm">International Standards
344 <term><acronym>ISSN
</acronym></term>
347 <ulink url=
"http://en.wikipedia.org/wiki/Issn">International Standard
348 Serial Number
</ulink>
354 <term><acronym>JDBC
</acronym></term>
358 url=
"http://en.wikipedia.org/wiki/Java_Database_Connectivity">Java
359 Database Connectivity
</ulink>
365 <term><acronym>LDAP
</acronym></term>
369 url=
"http://en.wikipedia.org/wiki/Lightweight_Directory_Access_Protocol">Lightweight
370 Directory Access Protocol
</ulink>
376 <term><acronym>MSVC
</acronym></term>
380 url=
"http://en.wikipedia.org/wiki/Visual_C++"><productname>Microsoft
381 Visual C
</productname></ulink>
387 <term><acronym>MVCC
</acronym></term>
390 <link linkend=
"mvcc">Multi-Version Concurrency Control
</link>
396 <term><acronym>NLS
</acronym></term>
400 url=
"http://en.wikipedia.org/wiki/Internationalization_and_localization">National
401 Language Support
</ulink>
407 <term><acronym>ODBC
</acronym></term>
411 url=
"http://en.wikipedia.org/wiki/Open_Database_Connectivity">Open
412 Database Connectivity
</ulink>
418 <term><acronym>OID
</acronym></term>
421 <link linkend=
"datatype-oid">Object Identifier
</link>
427 <term><acronym>OLAP
</acronym></term>
430 <ulink url=
"http://en.wikipedia.org/wiki/Olap">Online Analytical
437 <term><acronym>OLTP
</acronym></term>
440 <ulink url=
"http://en.wikipedia.org/wiki/OLTP">Online Transaction
447 <term><acronym>ORDBMS
</acronym></term>
450 <ulink url=
"http://en.wikipedia.org/wiki/ORDBMS">Object-Relational
451 Database Management System
</ulink>
457 <term><acronym>PAM
</acronym></term>
461 url=
"http://en.wikipedia.org/wiki/Pluggable_Authentication_Modules">Pluggable
462 Authentication Modules
</ulink>
468 <term><acronym>PGSQL
</acronym></term>
471 <link linkend=
"postgres"><productname>PostgreSQL<
/></link>
477 <term><acronym>PGXS
</acronym></term>
480 <link linkend=
"xfunc-c-pgxs"><productname>PostgreSQL<
/> Extension System
</link>
486 <term><acronym>PID
</acronym></term>
489 <ulink url=
"http://en.wikipedia.org/wiki/Process_identifier">Process Identifier
</ulink>
495 <term><acronym>PITR
</acronym></term>
498 <link linkend=
"continuous-archiving">Point-In-Time
499 Recovery
</link> (Continuous Archiving)
505 <term><acronym>PL
</acronym></term>
508 <link linkend=
"server-programming">Programming Languages (server-side)
</link>
514 <term><acronym>POSIX
</acronym></term>
517 <ulink url=
"http://en.wikipedia.org/wiki/POSIX">Portable Operating
518 System Interface
</ulink>
524 <term><acronym>RDBMS
</acronym></term>
528 url=
"http://en.wikipedia.org/wiki/Relational_database_management_system">Relational
529 Database Management System
</ulink>
535 <term><acronym>RFC
</acronym></term>
539 url=
"http://en.wikipedia.org/wiki/Request_for_Comments">Request For
546 <term><acronym>SGML
</acronym></term>
549 <ulink url=
"http://en.wikipedia.org/wiki/SGML">Standard Generalized
550 Markup Language
</ulink>
556 <term><acronym>SPI
</acronym></term>
559 <link linkend=
"spi">Server Programming Interface
</link>
565 <term><acronym>SQL
</acronym></term>
568 <ulink url=
"http://en.wikipedia.org/wiki/SQL">Structured Query Language
</ulink>
574 <term><acronym>SRF
</acronym></term>
577 <link linkend=
"xfunc-c-return-set">Set-Returning Function
</link>
583 <term><acronym>SSH
</acronym></term>
586 <ulink url=
"http://en.wikipedia.org/wiki/Secure_Shell">Secure
593 <term><acronym>SSL
</acronym></term>
596 <ulink url=
"http://en.wikipedia.org/wiki/Secure_Sockets_Layer">Secure Sockets Layer
</ulink>
602 <term><acronym>SSPI
</acronym></term>
605 <ulink url=
"http://msdn2.microsoft.com/en-us/library/aa380493.aspx">Security
606 Support Provider Interface
</ulink>
612 <term><acronym>SYSV
</acronym></term>
615 <ulink url=
"http://en.wikipedia.org/wiki/System_V">Unix System V
</ulink>
621 <term><acronym>TCP/IP
</acronym></term>
625 url=
"http://en.wikipedia.org/wiki/Transmission_Control_Protocol">Transmission
626 Control Protocol (TCP) / Internet Protocol (IP)
</ulink>
632 <term><acronym>TID
</acronym></term>
635 <link linkend=
"datatype-oid">Tuple Identifier
</link>
641 <term><acronym>TOAST
</acronym></term>
644 <link linkend=
"storage-toast">The Oversized-Attribute Storage Technique
</link>
650 <term><acronym>TPC
</acronym></term>
653 <ulink url=
"http://www.tpc.org/">Transaction Processing
654 Performance Council
</ulink>
660 <term><acronym>URL
</acronym></term>
663 <ulink url=
"http://en.wikipedia.org/wiki/URL">Uniform Resource
670 <term><acronym>UTC
</acronym></term>
674 url=
"http://en.wikipedia.org/wiki/Coordinated_Universal_Time">Coordinated
675 Universal Time
</ulink>
681 <term><acronym>UTF
</acronym></term>
684 <ulink url=
"http://www.unicode.org/">Unicode Transformation
691 <term><acronym>UTF8
</acronym></term>
694 <ulink url=
"http://en.wikipedia.org/wiki/Utf8">Eight-Bit Unicode
695 Transformation Format
</ulink>
701 <term><acronym>UUID
</acronym></term>
704 <link linkend=
"datatype-uuid">Universally Unique Identifier
</link>
710 <term><acronym>WAL
</acronym></term>
713 <link linkend=
"wal">Write-Ahead Log
</link>
719 <term><acronym>XID
</acronym></term>
722 <link linkend=
"datatype-oid">Transaction Identifier
</link>
728 <term><acronym>XML
</acronym></term>
731 <ulink url=
"http://en.wikipedia.org/wiki/XML">Extensible Markup