<term><acronym>CVE</acronym></term>

<listitem>

<para>

<ulink url="http://cve.mitre.org/">Common Vulnerabilities and Exposures</ulink>

<ulink url="https://cve.mitre.org/">Common Vulnerabilities and Exposures</ulink>

</para>

</listitem>

</varlistentry>

<term><acronym>IEEE</acronym></term>

<listitem>

<para>

<ulink url="http://standards.ieee.org/">Institute of Electrical and

<ulink url="https://standards.ieee.org/">Institute of Electrical and

Electronics Engineers</ulink>

</para>

</listitem>

<listitem>

<para>

<ulink

url="http://json.org">JavaScript Object Notation</ulink>

url="https://www.json.org">JavaScript Object Notation</ulink>

</para>

</listitem>

</varlistentry>

Some white papers and technical reports from the original

<productname>POSTGRES</productname> development team

are available at the University of California, Berkeley, Computer Science

Department <ulink url="http://db.cs.berkeley.edu/papers/">web site</ulink>.

Department <ulink url="https://dsf.berkeley.edu/papers/">web site</ulink>.

</para>

<bibliodiv>

</biblioentry>

<biblioentry id="sqltr-19075-6">

<title><ulink url="http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip">SQL Technical Report</ulink></title>

<title><ulink url="https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip">SQL Technical Report</ulink></title>

<subtitle>Part 6: SQL support for JavaScript Object

Notation (JSON)</subtitle>

<edition>First Edition</edition>

</biblioentry>

<biblioentry id="fong">

<title><ulink url="http://db.cs.berkeley.edu/papers/UCB-MS-zfong.pdf">The

<title><ulink url="https://dsf.berkeley.edu/papers/UCB-MS-zfong.pdf">The

design and implementation of the <productname>POSTGRES</productname> query

optimizer</ulink></title>

<author>

<biblioentry id="rowe87">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M87-13.pdf">The <productname>POSTGRES</productname>

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M87-13.pdf">The <productname>POSTGRES</productname>

data model</ulink></title>

<authorgroup>

<author>

<biblioentry id="seshadri95">

<biblioset relation="article">

<title><ulink url="http://citeseer.ist.psu.edu/seshadri95generalized.html">Generalized

<title><ulink url="https://citeseer.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.5740">Generalized

Partial Indexes</ulink></title>

<authorgroup>

<author>

<biblioentry id="ston86">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf">The

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M85-95.pdf">The

design of <productname>POSTGRES</productname></ulink></title>

<authorgroup>

<author>

<biblioentry id="ston87b">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M87-06.pdf">The

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M87-06.pdf">The

design of the <productname>POSTGRES</productname> storage

system</ulink></title>

<authorgroup>

<biblioentry id="ston89">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M89-82.pdf">A

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M89-82.pdf">A

commentary on the <productname>POSTGRES</productname> rules

system</ulink></title>

<authorgroup>

<biblioentry id="ston89b">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf">The

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M89-17.pdf">The

case for partial indexes</ulink></title>

<authorgroup>

<author>

<biblioentry id="ston90a">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M90-34.pdf">The

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M90-34.pdf">The

implementation of <productname>POSTGRES</productname></ulink></title>

<authorgroup>

<author>

<biblioentry id="ston90b">

<biblioset relation="article">

<title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M90-36.pdf">On

<title><ulink url="https://dsf.berkeley.edu/papers/ERL-M90-36.pdf">On

Rules, Procedures, Caching and Views in Database Systems</ulink></title>

<authorgroup>

<author>

by <xref linkend="guc-log-timezone"/>.)

The supported <literal>%</literal>-escapes are similar to those

listed in the Open Group's <ulink

url="http://pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html">strftime

url="https://pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html">strftime

</ulink> specification.

Note that the system's <function>strftime</function> is not used

directly, so platform-specific (nonstandard) extensions do not work.

<para>

My thanks are primarily to Prof. Joe Hellerstein

(<ulink url="http://db.cs.berkeley.edu/jmh/"></ulink>) for elucidating the

(<ulink url="https://dsf.berkeley.edu/jmh/"></ulink>) for elucidating the

gist of the GiST (<ulink url="http://gist.cs.berkeley.edu/"></ulink>), and

to his former student Andy Dong for his example written for Illustra.

I am also grateful to all Postgres developers, present and past, for

<tip>

<para>

If this is too complicated for you, you should consider using

<ulink url="http://www.gnu.org/software/libtool/">

<ulink url="https://www.gnu.org/software/libtool/">

<productname>GNU Libtool</productname></ulink>,

which hides the platform differences behind a uniform interface.

</para>

<para>

In this module, the Earth is assumed to be perfectly spherical.

(If that's too inaccurate for you, you might want to look at the

<application><ulink url="http://postgis.net/">PostGIS</ulink></application>

<application><ulink url="https://postgis.net/">PostGIS</ulink></application>

project.)

</para>

<entry>libpqxx</entry>

<entry>C++</entry>

<entry>C++ interface</entry>

<entry><ulink url="http://pqxx.org/"></ulink></entry>

<entry><ulink url="https://pqxx.org/"></ulink></entry>

</row>

<row>

<entry>Npgsql</entry>

<entry>.NET</entry>

<entry>.NET data provider</entry>

<entry><ulink url="http://www.npgsql.org/"></ulink></entry>

<entry><ulink url="https://www.npgsql.org/"></ulink></entry>

</row>

<row>

<entry>psycopg</entry>

<entry>Python</entry>

<entry>DB API 2.0-compliant</entry>

<entry><ulink url="http://initd.org/psycopg/"></ulink></entry>

<entry><ulink url="https://www.psycopg.org/"></ulink></entry>

</row>

</tbody>

</tgroup>

contains several extensions, which are described in

<xref linkend="contrib"/>. Other extensions are developed

independently, like <application><ulink

url="http://postgis.net/">PostGIS</ulink></application>. Even

url="https://postgis.net/">PostGIS</ulink></application>. Even

<productname>PostgreSQL</productname> replication solutions can be developed

externally. For example, <application> <ulink

url="http://www.slony.info">Slony-I</ulink></application> is a popular

url="https://www.slony.info">Slony-I</ulink></application> is a popular

primary/standby replication solution that is developed independently

from the core project.

</para>

<listitem>

<para>

<ulink url="http://www.red3d.com/cwr/evolve.html">

<ulink url="https://www.red3d.com/cwr/evolve.html">

Evolutionary Computation and its application to art and design</ulink>, by

Craig Reynolds

</para>

<listitem><para>

Required for GSSAPI authentication support. MIT Kerberos can be

downloaded from

<ulink url="http://web.mit.edu/Kerberos/dist/index.html"></ulink>.

<ulink url="https://web.mit.edu/Kerberos/dist/index.html"></ulink>.

</para></listitem>

</varlistentry>

<productname>libxslt</productname></term>

<listitem><para>

Required for XML support. Binaries can be downloaded from

<ulink url="http://zlatkovic.com/pub/libxml"></ulink> or source from

<ulink url="https://zlatkovic.com/pub/libxml"></ulink> or source from

<ulink url="http://xmlsoft.org"></ulink>. Note that libxml2 requires iconv,

which is available from the same download location.

</para></listitem>

<listitem><para>

Required for compression support in <application>pg_dump</application>

and <application>pg_restore</application>. Binaries can be downloaded

from <ulink url="http://www.zlib.net"></ulink>.

from <ulink url="https://www.zlib.net"></ulink>.

</para></listitem>

</varlistentry>

<para>

<productname>PostgreSQL</productname> is an object-relational

database management system (<acronym>ORDBMS</acronym>) based on

<ulink url="http://db.cs.berkeley.edu/postgres.html">

<ulink url="https://dsf.berkeley.edu/postgres.html">

<productname>POSTGRES, Version 4.2</productname></ulink>,

developed at the University of California at Berkeley Computer Science

Department. POSTGRES pioneered many concepts that only became