<sect1>

<sect1 id="adminpack">

<title>adminpack</title>

<indexterm zone="adminpack">

<primary>adminpack</primary>

</indexterm>

<para>

adminpack is a PostgreSQL standard module that implements a number of

support functions which pgAdmin and other administration and management tools

</sect2>

</sect1>

<sect1>

<!--

<sect1 id="btree-gist">

<title>btree_gist</title>

<indexterm zone="btree-gist">

<primary>btree-gist</primary>

<primary>btree_gist</primary>

</indexterm>

-->

<title>btree-gist</title>

<para>

btree-gist is a B-Tree implementation using GiST that supports the int2, int4,

btree_gist is a B-Tree implementation using GiST that supports the int2, int4,

int8, float4, float8 timestamp with/without time zone, time

with/without time zone, date, interval, oid, money, macaddr, char,

varchar/text, bytea, numeric, bit, varbit and inet/cidr types.

</sect2>

</sect1>

<!-- $PostgreSQL: pgsql/doc/src/sgml/contrib.sgml,v 1.5 2007/12/0221:13:34 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/contrib.sgml,v 1.6 2007/12/0222:33:20 tgl Exp $ -->

<appendix id="contrib">

<title>Additional Supplied Modules</title>

&oid2name;

&pageinspect;

&pgbench;

&buffercache;

&pgbuffercache;

&pgcrypto;

&freespacemap;

&pgfreespacemap;

&pgrowlocks;

&standby;

&pgstandby;

&pgstattuple;

&trgm;

&pgtrgm;

&seg;

&sslinfo;

&tablefunc;

<!-- $PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.56 2007/01/31 20:56:16 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.57 2007/12/02 22:33:20 tgl Exp $ -->

<appendix id="datetime-appendix">

<title>Date/Time Support</title>

dates and times.

</para>

<sect1>

<sect1 id="datetime-input-rules">

<title>Date/Time Input Interpretation</title>

<para>

<!-- <reference> -->

<sect1 id="dblink">

<title>dblink</title>

<indexterm zone="dblink">

<primary>dblink</primary>

</indexterm>

<para>

dblink is a contrib module which allows connections with

<literal>dblink</> is a module which allows connections with

other databases.

</para>

<!-- dblink_connect -->

<refentry>

<refentry id="CONTRIB-DBLINK-CONNECT">

<refnamediv>

<refname>dblink_connect</refname>

<refpurpose>opens a persistent connection to a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_disconnect -->

<refentry>

<refentry id="CONTRIB-DBLINK-DISCONNECT">

<refnamediv>

<refname>dblink_disconnect</refname>

<refpurpose>closes a persistent connection to a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_open -->

<refentry>

<refentry id="CONTRIB-DBLINK-OPEN">

<refnamediv>

<refname>dblink_open</refname>

<refpurpose>opens a cursor on a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_fetch -->

<refentry>

<refentry id="CONTRIB-DBLINK-FETCH">

<refnamediv>

<refname>dblink_fetch</refname>

<refpurpose>returns a set from an open cursor on a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_close -->

<refentry>

<refentry id="CONTRIB-DBLINK-CLOSE">

<refnamediv>

<refname>dblink_close</refname>

<refpurpose>closes a cursor on a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_exec -->

<refentry>

<refentry id="CONTRIB-DBLINK-EXEC">

<refnamediv>

<refname>dblink_exec</refname>

<refpurpose>executes an UPDATE/INSERT/DELETE on a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_current_query -->

<refentry>

<refentry id="CONTRIB-DBLINK-CURRENT-QUERY">

<refnamediv>

<refname>dblink_current_query</refname>

<refpurpose>returns the current query string</refpurpose>

</refsect1>

</refentry>

<!-- dblink_get_pkey -->

<refentry>

<refentry id="CONTRIB-DBLINK-GET-PKEY">

<refnamediv>

<refname>dblink_get_pkey</refname>

<refpurpose>returns the position and field names of a relation's

</refsect1>

</refentry>

<!-- dblink_build_sql_insert -->

<refentry>

<refentry id="CONTRIB-DBLINK-BUILD-SQL-INSERT">

<refnamediv>

<refname>dblink_build_sql_insert</refname>

<refpurpose>

</refsect1>

</refentry>

<!-- dblink_build_sql_delete -->

<refentry>

<refentry id="CONTRIB-DBLINK-BUILD-SQL-DELETE">

<refnamediv>

<refname>dblink_build_sql_delete</refname>

<refpurpose>builds a delete statement using supplied values for selection

</refsect1>

</refentry>

<!-- dblink_build_sql_update -->

<refentry>

<refentry id="CONTRIB-DBLINK-BUILD-SQL-UPDATE">

<refnamediv>

<refname>dblink_build_sql_update</refname>

<refpurpose>builds an update statement using a local tuple, replacing

</refsect1>

</refentry>

<!-- dblink_get_connections -->

<refentry>

<refentry id="CONTRIB-DBLINK-GET-CONNECTIONS">

<refnamediv>

<refname>dblink_get_connections</refname>

<refpurpose>returns a text array of all active named dblink connections</refpurpose>

</refsect1>

</refentry>

<!-- dblinkd_is_busy -->

<refentry>

<refentry id="CONTRIB-DBLINK-IS-BUSY">

<refnamediv>

<refname>dblink_is_busy</refname>

<refpurpose>checks to see if named connection is busy with an async query</refpurpose>

</refsect1>

</refentry>

<!-- dblink_cancel_query -->

<refentry>

<refentry id="CONTRIB-DBLINK-CANCEL-QUERY">

<refnamediv>

<refname>dblink_cancel_query</refname>

<refpurpose>cancels any active query on the named connection</refpurpose>

</refsect1>

</refentry>

<!-- dblink_error_message -->

<refentry>

<refentry id="CONTRIB-DBLINK-ERROR-MESSAGE">

<refnamediv>

<refname>dblink_error_message</refname>

<refpurpose>gets last error message on the named connection</refpurpose>

</refsect1>

</refentry>

<!-- dblink -->

<refentry>

<refentry id="CONTRIB-DBLINK">

<refnamediv>

<refname>dblink</refname>

<refpurpose>returns a set from a remote database</refpurpose>

</refsect1>

</refentry>

<!-- dblink_send_query -->

<refentry>

<refentry id="CONTRIB-DBLINK-SEND-QUERY">

<refnamediv>

<refname>dblink_send_query</refname>

<refpurpose>sends an async query to a remote database</refpurpose>

<literal>

SELECT dblink_connect('dtest1', 'dbname=contrib_regression');

SELECT * FROM

dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1< 3') AS t1;

dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1&lt; 3') AS t1;

</literal>

</para>

</refsect1>

</refentry>

<!-- dblink_get_result -->

<refentry>

<refentry id="CONTRIB-DBLINK-GET-RESULT">

<refnamediv>

<refname>dblink_get_result</refname>

<refpurpose>gets an async query result</refpurpose>

(1 row)

contrib_regression=# SELECT * from

contrib_regression-# dblink_send_query('dtest1', 'select * from foo where f1< 3') as t1;

contrib_regression-# dblink_send_query('dtest1', 'select * from foo where f1&lt; 3') as t1;

t1

----

1

(0 rows)

contrib_regression=# SELECT * from

dblink_send_query('dtest1', 'select * from foo where f1< 3; select * from foo where f1> 6') as t1;

dblink_send_query('dtest1', 'select * from foo where f1&lt; 3; select * from foo where f1&gt; 6') as t1;

t1

----

1

<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.54 2007/12/0221:13:34 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.55 2007/12/0222:33:20 tgl Exp $ -->

<!entity history SYSTEM "history.sgml">

<!entity info SYSTEM "info.sgml">

<!entity oid2name SYSTEM "oid2name.sgml">

<!entity pageinspect SYSTEM "pageinspect.sgml">

<!entity pgbench SYSTEM "pgbench.sgml">

<!entitybuffercacheSYSTEM "buffercache.sgml">

<!entitypgbuffercache SYSTEM "pgbuffercache.sgml">

<!entity pgcrypto SYSTEM "pgcrypto.sgml">

<!entityfreespacemapSYSTEM "freespacemap.sgml">

<!entitypgfreespacemapSYSTEM "pgfreespacemap.sgml">

<!entity pgrowlocks SYSTEM "pgrowlocks.sgml">

<!entitystandbySYSTEM "standby.sgml">

<!entitypgstandby SYSTEM "pgstandby.sgml">

<!entity pgstattuple SYSTEM "pgstattuple.sgml">

<!entitytrgmSYSTEM "trgm.sgml">

<!entitypgtrgm SYSTEM "pgtrgm.sgml">

<!entity seg SYSTEM "seg.sgml">

<!entity sslinfo SYSTEM "sslinfo.sgml">

<!entity tablefunc SYSTEM "tablefunc.sgml">

<!-- $PostgreSQL: pgsql/doc/src/sgml/install-win32.sgml,v 1.42 2007/11/28 15:42:31 petere Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/install-win32.sgml,v 1.43 2007/12/02 22:33:20 tgl Exp $ -->

<chapter id="install-win32">

<title>Installation on <productname>Windows</productname></title>

<productname>Windows 98</productname>.

</para>

<sect1>

<sect1 id="install-win32-full">

<title>Building with <productname>Visual C++ 2005</productname></title>

<para>

</sect1>

<sect1>

<sect1 id="install-win32-libpq">

<title>Building <application>libpq</application> with

<productname>Visual C++</productname> or

<productname>Borland C++</productname></title>

<sect1 id="buffercache">

<sect1 id="pgbuffercache">

<title>pg_buffercache</title>

<indexterm zone="buffercache">

<indexterm zone="pgbuffercache">

<primary>pg_buffercache</primary>

</indexterm>

<para>

<literal>pg_buffercache</literal> module providesthe means for examining

The<literal>pg_buffercache</literal> module providesa means for examining

what's happening to the buffercache at any given time without having to

restart or rebuild the server with debugging code added. The intent is to

do for the buffercache what pg_locks does for locks.

</sect2>

</sect1>

<sect1 id="pgfreespacemap">

<title>pgfreespacemap</title>

<title>pg_freespacemap</title>

<indexterm zone="pgfreespacemap">

<primary>pgfreespacemap</primary>

<primary>pg_freespacemap</primary>

</indexterm>

<para>

Thismodules providesthe means for examining the free space map (FSM). It

Thismodule providesa means for examining the free space map (FSM). It

consists of two C functions: <literal>pg_freespacemap_relations()</literal>

and <literal>pg_freespacemap_pages()</literal> that return a set

of records, plus two views <literal>pg_freespacemap_relations</literal> and

</para>

</sect2>

</sect1>