<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>Client Interfaces</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 7.4.1 Documentation"
HREF="index.html"><LINK
REL="PREVIOUS"
TITLE="Platform-specific comparison files"
HREF="regress-platform.html"><LINK
REL="NEXT"
TITLE="libpq - C Library"
HREF="libpq.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
NAME="creation"
CONTENT="2003-12-22T03:48:47"></HEAD
><BODY
CLASS="PART"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
>PostgreSQL 7.4.1 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="regress-platform.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="admin.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="server-programming.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="libpq.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="PART"
><A
NAME="CLIENT-INTERFACES"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="TITLE"
>IV. Client Interfaces</H1
><DIV
CLASS="PARTINTRO"
><A
NAME="AEN19840"
></A
><P
> This part describes the client programming interfaces distributed
with <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>. Each of these chapters can be
read independently. Note that there are many other programming
interfaces for client programs that are distributed separately and
contain their own documentation. Readers of this part should be
familiar with using <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> commands to manipulate
and query the database (see <A
HREF="sql.html"
>Part II</A
>) and of course
with the programming language that the interface uses.
</P
></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>27. <A
HREF="libpq.html"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> - C Library</A
></DT
><DD
><DL
><DT
>27.1. <A
HREF="libpq.html#LIBPQ-CONNECT"
>Database Connection Control Functions</A
></DT
><DT
>27.2. <A
HREF="libpq-status.html"
>Connection Status Functions</A
></DT
><DT
>27.3. <A
HREF="libpq-exec.html"
>Command Execution Functions</A
></DT
><DT
>27.4. <A
HREF="libpq-async.html"
>Asynchronous Command Processing</A
></DT
><DT
>27.5. <A
HREF="libpq-fastpath.html"
>The Fast-Path Interface</A
></DT
><DT
>27.6. <A
HREF="libpq-notify.html"
>Asynchronous Notification</A
></DT
><DT
>27.7. <A
HREF="libpq-copy.html"
>Functions Associated with the <TT
CLASS="COMMAND"
>COPY</TT
> Command</A
></DT
><DT
>27.8. <A
HREF="libpq-control.html"
>Control Functions</A
></DT
><DT
>27.9. <A
HREF="libpq-notice-processing.html"
>Notice Processing</A
></DT
><DT
>27.10. <A
HREF="libpq-envars.html"
>Environment Variables</A
></DT
><DT
>27.11. <A
HREF="libpq-pgpass.html"
>The Password File</A
></DT
><DT
>27.12. <A
HREF="libpq-threading.html"
>Behavior in Threaded Programs</A
></DT
><DT
>27.13. <A
HREF="libpq-build.html"
>Building <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> Programs</A
></DT
><DT
>27.14. <A
HREF="libpq-example.html"
>Example Programs</A
></DT
></DL
></DD
><DT
>28. <A
HREF="largeobjects.html"
>Large Objects</A
></DT
><DD
><DL
><DT
>28.1. <A
HREF="largeobjects.html#LO-HISTORY"
>History</A
></DT
><DT
>28.2. <A
HREF="lo-implementation.html"
>Implementation Features</A
></DT
><DT
>28.3. <A
HREF="lo-interfaces.html"
>Client Interfaces</A
></DT
><DT
>28.4. <A
HREF="lo-funcs.html"
>Server-Side Functions</A
></DT
><DT
>28.5. <A
HREF="lo-examplesect.html"
>Example Program</A
></DT
></DL
></DD
><DT
>29. <A
HREF="pgtcl.html"
><SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> - Tcl Binding Library</A
></DT
><DD
><DL
><DT
>29.1. <A
HREF="pgtcl.html#PGTCL-OVERVIEW"
>Overview</A
></DT
><DT
>29.2. <A
HREF="libpgtcl-loading.html"
>Loading <SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> into an Application</A
></DT
><DT
>29.3. <A
HREF="libpgtcl-ref.html"
><SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> Command Reference</A
></DT
><DT
>29.4. <A
HREF="pgtcl-examplesect.html"
>Example Program</A
></DT
></DL
></DD
><DT
>30. <A
HREF="ecpg.html"
><SPAN
CLASS="APPLICATION"
>ECPG</SPAN
> - Embedded <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> in C</A
></DT
><DD
><DL
><DT
>30.1. <A
HREF="ecpg.html#ECPG-CONCEPT"
>The Concept</A
></DT
><DT
>30.2. <A
HREF="ecpg-connect.html"
>Connecting to the Database Server</A
></DT
><DT
>30.3. <A
HREF="ecpg-disconnect.html"
>Closing a Connection</A
></DT
><DT
>30.4. <A
HREF="ecpg-commands.html"
>Running SQL Commands</A
></DT
><DT
>30.5. <A
HREF="ecpg-set-connection.html"
>Choosing a Connection</A
></DT
><DT
>30.6. <A
HREF="ecpg-variables.html"
>Using Host Variables</A
></DT
><DT
>30.7. <A
HREF="ecpg-dynamic.html"
>Dynamic SQL</A
></DT
><DT
>30.8. <A
HREF="ecpg-descriptors.html"
>Using SQL Descriptor Areas</A
></DT
><DT
>30.9. <A
HREF="ecpg-errors.html"
>Error Handling</A
></DT
><DT
>30.10. <A
HREF="ecpg-include.html"
>Including Files</A
></DT
><DT
>30.11. <A
HREF="ecpg-process.html"
>Processing Embedded SQL Programs</A
></DT
><DT
>30.12. <A
HREF="ecpg-library.html"
>Library Functions</A
></DT
><DT
>30.13. <A
HREF="ecpg-develop.html"
>Internals</A
></DT
></DL
></DD
><DT
>31. <A
HREF="jdbc.html"
><ACRONYM
CLASS="ACRONYM"
>JDBC</ACRONYM
> Interface</A
></DT
><DD
><DL
><DT
>31.1. <A
HREF="jdbc.html#JDBC-SETUP"
>Setting up the <ACRONYM
CLASS="ACRONYM"
>JDBC</ACRONYM
> Driver</A
></DT
><DT
>31.2. <A
HREF="jdbc-use.html"
>Initializing the Driver</A
></DT
><DT
>31.3. <A
HREF="jdbc-query.html"
>Issuing a Query and Processing the Result</A
></DT
><DT
>31.4. <A
HREF="jdbc-update.html"
>Performing Updates</A
></DT
><DT
>31.5. <A
HREF="jdbc-callproc.html"
>Calling Stored Functions</A
></DT
><DT
>31.6. <A
HREF="jdbc-ddl.html"
>Creating and Modifying Database Objects</A
></DT
><DT
>31.7. <A
HREF="jdbc-binary-data.html"
>Storing Binary Data</A
></DT
><DT
>31.8. <A
HREF="jdbc-ext.html"
><SPAN
CLASS="APPLICATION"
>PostgreSQL</SPAN
> Extensions to the
<ACRONYM
CLASS="ACRONYM"
>JDBC</ACRONYM
> <ACRONYM
CLASS="ACRONYM"
>API</ACRONYM
></A
></DT
><DT
>31.9. <A
HREF="jdbc-thread.html"
>Using the Driver in a Multithreaded or a Servlet Environment</A
></DT
><DT
>31.10. <A
HREF="jdbc-datasource.html"
>Connection Pools and Data Sources</A
></DT
><DT
>31.11. <A
HREF="jdbc-reading.html"
>Further Reading</A
></DT
></DL
></DD
><DT
>32. <A
HREF="information-schema.html"
>The Information Schema</A
></DT
><DD
><DL
><DT
>32.1. <A
HREF="information-schema.html#INFOSCHEMA-SCHEMA"
>The Schema</A
></DT
><DT
>32.2. <A
HREF="infoschema-datatypes.html"
>Data Types</A
></DT
><DT
>32.3. <A
HREF="infoschema-information-schema-catalog-name.html"
><TT
CLASS="LITERAL"
>information_schema_catalog_name</TT
></A
></DT
><DT
>32.4. <A
HREF="infoschema-applicable-roles.html"
><TT
CLASS="LITERAL"
>applicable_roles</TT
></A
></DT
><DT
>32.5. <A
HREF="infoschema-check-constraints.html"
><TT
CLASS="LITERAL"
>check_constraints</TT
></A
></DT
><DT
>32.6. <A
HREF="infoschema-column-domain-usage.html"
><TT
CLASS="LITERAL"
>column_domain_usage</TT
></A
></DT
><DT
>32.7. <A
HREF="infoschema-column-privileges.html"
><TT
CLASS="LITERAL"
>column_privileges</TT
></A
></DT
><DT
>32.8. <A
HREF="infoschema-column-udt-usage.html"
><TT
CLASS="LITERAL"
>column_udt_usage</TT
></A
></DT
><DT
>32.9. <A
HREF="infoschema-columns.html"
><TT
CLASS="LITERAL"
>columns</TT
></A
></DT
><DT
>32.10. <A
HREF="infoschema-constraint-column-usage.html"
><TT
CLASS="LITERAL"
>constraint_column_usage</TT
></A
></DT
><DT
>32.11. <A
HREF="infoschema-constraint-table-usage.html"
><TT
CLASS="LITERAL"
>constraint_table_usage</TT
></A
></DT
><DT
>32.12. <A
HREF="infoschema-data-type-privileges.html"
><TT
CLASS="LITERAL"
>data_type_privileges</TT
></A
></DT
><DT
>32.13. <A
HREF="infoschema-domain-constraints.html"
><TT
CLASS="LITERAL"
>domain_constraints</TT
></A
></DT
><DT
>32.14. <A
HREF="infoschema-domain-udt-usage.html"
><TT
CLASS="LITERAL"
>domain_udt_usage</TT
></A
></DT
><DT
>32.15. <A
HREF="infoschema-domains.html"
><TT
CLASS="LITERAL"
>domains</TT
></A
></DT
><DT
>32.16. <A
HREF="infoschema-element-types.html"
><TT
CLASS="LITERAL"
>element_types</TT
></A
></DT
><DT
>32.17. <A
HREF="infoschema-enabled-roles.html"
><TT
CLASS="LITERAL"
>enabled_roles</TT
></A
></DT
><DT
>32.18. <A
HREF="infoschema-key-column-usage.html"
><TT
CLASS="LITERAL"
>key_column_usage</TT
></A
></DT
><DT
>32.19. <A
HREF="infoschema-parameters.html"
><TT
CLASS="LITERAL"
>parameters</TT
></A
></DT
><DT
>32.20. <A
HREF="infoschema-referential-constraints.html"
><TT
CLASS="LITERAL"
>referential_constraints</TT
></A
></DT
><DT
>32.21. <A
HREF="infoschema-role-column-grants.html"
><TT
CLASS="LITERAL"
>role_column_grants</TT
></A
></DT
><DT
>32.22. <A
HREF="infoschema-role-routine-grants.html"
><TT
CLASS="LITERAL"
>role_routine_grants</TT
></A
></DT
><DT
>32.23. <A
HREF="infoschema-role-table-grants.html"
><TT
CLASS="LITERAL"
>role_table_grants</TT
></A
></DT
><DT
>32.24. <A
HREF="infoschema-role-usage-grants.html"
><TT
CLASS="LITERAL"
>role_usage_grants</TT
></A
></DT
><DT
>32.25. <A
HREF="infoschema-routine-privileges.html"
><TT
CLASS="LITERAL"
>routine_privileges</TT
></A
></DT
><DT
>32.26. <A
HREF="infoschema-routines.html"
><TT
CLASS="LITERAL"
>routines</TT
></A
></DT
><DT
>32.27. <A
HREF="infoschema-schemata.html"
><TT
CLASS="LITERAL"
>schemata</TT
></A
></DT
><DT
>32.28. <A
HREF="infoschema-sql-features.html"
><TT
CLASS="LITERAL"
>sql_features</TT
></A
></DT
><DT
>32.29. <A
HREF="infoschema-sql-implementation-info.html"
><TT
CLASS="LITERAL"
>sql_implementation_info</TT
></A
></DT
><DT
>32.30. <A
HREF="infoschema-sql-languages.html"
><TT
CLASS="LITERAL"
>sql_languages</TT
></A
></DT
><DT
>32.31. <A
HREF="infoschema-sql-packages.html"
><TT
CLASS="LITERAL"
>sql_packages</TT
></A
></DT
><DT
>32.32. <A
HREF="infoschema-sql-sizing.html"
><TT
CLASS="LITERAL"
>sql_sizing</TT
></A
></DT
><DT
>32.33. <A
HREF="infoschema-sql-sizing-profiles.html"
><TT
CLASS="LITERAL"
>sql_sizing_profiles</TT
></A
></DT
><DT
>32.34. <A
HREF="infoschema-table-constraints.html"
><TT
CLASS="LITERAL"
>table_constraints</TT
></A
></DT
><DT
>32.35. <A
HREF="infoschema-table-privileges.html"
><TT
CLASS="LITERAL"
>table_privileges</TT
></A
></DT
><DT
>32.36. <A
HREF="infoschema-tables.html"
><TT
CLASS="LITERAL"
>tables</TT
></A
></DT
><DT
>32.37. <A
HREF="infoschema-triggers.html"
><TT
CLASS="LITERAL"
>triggers</TT
></A
></DT
><DT
>32.38. <A
HREF="infoschema-usage-privileges.html"
><TT
CLASS="LITERAL"
>usage_privileges</TT
></A
></DT
><DT
>32.39. <A
HREF="infoschema-view-column-usage.html"
><TT
CLASS="LITERAL"
>view_column_usage</TT
></A
></DT
><DT
>32.40. <A
HREF="infoschema-view-table-usage.html"
><TT
CLASS="LITERAL"
>view_table_usage</TT
></A
></DT
><DT
>32.41. <A
HREF="infoschema-views.html"
><TT
CLASS="LITERAL"
>views</TT
></A
></DT
></DL
></DD
></DL
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="regress-platform.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="libpq.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Platform-specific comparison files</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
> </TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> - C Library</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
