<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Client Interfaces</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 8.0.11 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 HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2007-02-02T03:57:22"></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 8.0.11 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="AEN22500" ></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 (<A HREF="external-projects.html" >Appendix H</A > lists some of the more popular ones). 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-cancel.html" >Cancelling Queries in Progress</A ></DT ><DT >27.6. <A HREF="libpq-fastpath.html" >The Fast-Path Interface</A ></DT ><DT >27.7. <A HREF="libpq-notify.html" >Asynchronous Notification</A ></DT ><DT >27.8. <A HREF="libpq-copy.html" >Functions Associated with the <TT CLASS="COMMAND" >COPY</TT > Command</A ></DT ><DT >27.9. <A HREF="libpq-control.html" >Control Functions</A ></DT ><DT >27.10. <A HREF="libpq-notice-processing.html" >Notice Processing</A ></DT ><DT >27.11. <A HREF="libpq-envars.html" >Environment Variables</A ></DT ><DT >27.12. <A HREF="libpq-pgpass.html" >The Password File</A ></DT ><DT >27.13. <A HREF="libpq-ssl.html" >SSL Support</A ></DT ><DT >27.14. <A HREF="libpq-threading.html" >Behavior in Threaded Programs</A ></DT ><DT >27.15. <A HREF="libpq-build.html" >Building <SPAN CLASS="APPLICATION" >libpq</SPAN > Programs</A ></DT ><DT >27.16. <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="ecpg.html" ><SPAN CLASS="APPLICATION" >ECPG</SPAN > - Embedded <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > in C</A ></DT ><DD ><DL ><DT >29.1. <A HREF="ecpg.html#ECPG-CONCEPT" >The Concept</A ></DT ><DT >29.2. <A HREF="ecpg-connect.html" >Connecting to the Database Server</A ></DT ><DT >29.3. <A HREF="ecpg-disconnect.html" >Closing a Connection</A ></DT ><DT >29.4. <A HREF="ecpg-commands.html" >Running SQL Commands</A ></DT ><DT >29.5. <A HREF="ecpg-set-connection.html" >Choosing a Connection</A ></DT ><DT >29.6. <A HREF="ecpg-variables.html" >Using Host Variables</A ></DT ><DT >29.7. <A HREF="ecpg-dynamic.html" >Dynamic SQL</A ></DT ><DT >29.8. <A HREF="ecpg-descriptors.html" >Using SQL Descriptor Areas</A ></DT ><DT >29.9. <A HREF="ecpg-errors.html" >Error Handling</A ></DT ><DT >29.10. <A HREF="ecpg-include.html" >Including Files</A ></DT ><DT >29.11. <A HREF="ecpg-process.html" >Processing Embedded SQL Programs</A ></DT ><DT >29.12. <A HREF="ecpg-library.html" >Library Functions</A ></DT ><DT >29.13. <A HREF="ecpg-develop.html" >Internals</A ></DT ></DL ></DD ><DT >30. <A HREF="information-schema.html" >The Information Schema</A ></DT ><DD ><DL ><DT >30.1. <A HREF="information-schema.html#INFOSCHEMA-SCHEMA" >The Schema</A ></DT ><DT >30.2. <A HREF="infoschema-datatypes.html" >Data Types</A ></DT ><DT >30.3. <A HREF="infoschema-information-schema-catalog-name.html" ><TT CLASS="LITERAL" >information_schema_catalog_name</TT ></A ></DT ><DT >30.4. <A HREF="infoschema-applicable-roles.html" ><TT CLASS="LITERAL" >applicable_roles</TT ></A ></DT ><DT >30.5. <A HREF="infoschema-check-constraints.html" ><TT CLASS="LITERAL" >check_constraints</TT ></A ></DT ><DT >30.6. <A HREF="infoschema-column-domain-usage.html" ><TT CLASS="LITERAL" >column_domain_usage</TT ></A ></DT ><DT >30.7. <A HREF="infoschema-column-privileges.html" ><TT CLASS="LITERAL" >column_privileges</TT ></A ></DT ><DT >30.8. <A HREF="infoschema-column-udt-usage.html" ><TT CLASS="LITERAL" >column_udt_usage</TT ></A ></DT ><DT >30.9. <A HREF="infoschema-columns.html" ><TT CLASS="LITERAL" >columns</TT ></A ></DT ><DT >30.10. <A HREF="infoschema-constraint-column-usage.html" ><TT CLASS="LITERAL" >constraint_column_usage</TT ></A ></DT ><DT >30.11. <A HREF="infoschema-constraint-table-usage.html" ><TT CLASS="LITERAL" >constraint_table_usage</TT ></A ></DT ><DT >30.12. <A HREF="infoschema-data-type-privileges.html" ><TT CLASS="LITERAL" >data_type_privileges</TT ></A ></DT ><DT >30.13. <A HREF="infoschema-domain-constraints.html" ><TT CLASS="LITERAL" >domain_constraints</TT ></A ></DT ><DT >30.14. <A HREF="infoschema-domain-udt-usage.html" ><TT CLASS="LITERAL" >domain_udt_usage</TT ></A ></DT ><DT >30.15. <A HREF="infoschema-domains.html" ><TT CLASS="LITERAL" >domains</TT ></A ></DT ><DT >30.16. <A HREF="infoschema-element-types.html" ><TT CLASS="LITERAL" >element_types</TT ></A ></DT ><DT >30.17. <A HREF="infoschema-enabled-roles.html" ><TT CLASS="LITERAL" >enabled_roles</TT ></A ></DT ><DT >30.18. <A HREF="infoschema-key-column-usage.html" ><TT CLASS="LITERAL" >key_column_usage</TT ></A ></DT ><DT >30.19. <A HREF="infoschema-parameters.html" ><TT CLASS="LITERAL" >parameters</TT ></A ></DT ><DT >30.20. <A HREF="infoschema-referential-constraints.html" ><TT CLASS="LITERAL" >referential_constraints</TT ></A ></DT ><DT >30.21. <A HREF="infoschema-role-column-grants.html" ><TT CLASS="LITERAL" >role_column_grants</TT ></A ></DT ><DT >30.22. <A HREF="infoschema-role-routine-grants.html" ><TT CLASS="LITERAL" >role_routine_grants</TT ></A ></DT ><DT >30.23. <A HREF="infoschema-role-table-grants.html" ><TT CLASS="LITERAL" >role_table_grants</TT ></A ></DT ><DT >30.24. <A HREF="infoschema-role-usage-grants.html" ><TT CLASS="LITERAL" >role_usage_grants</TT ></A ></DT ><DT >30.25. <A HREF="infoschema-routine-privileges.html" ><TT CLASS="LITERAL" >routine_privileges</TT ></A ></DT ><DT >30.26. <A HREF="infoschema-routines.html" ><TT CLASS="LITERAL" >routines</TT ></A ></DT ><DT >30.27. <A HREF="infoschema-schemata.html" ><TT CLASS="LITERAL" >schemata</TT ></A ></DT ><DT >30.28. <A HREF="infoschema-sql-features.html" ><TT CLASS="LITERAL" >sql_features</TT ></A ></DT ><DT >30.29. <A HREF="infoschema-sql-implementation-info.html" ><TT CLASS="LITERAL" >sql_implementation_info</TT ></A ></DT ><DT >30.30. <A HREF="infoschema-sql-languages.html" ><TT CLASS="LITERAL" >sql_languages</TT ></A ></DT ><DT >30.31. <A HREF="infoschema-sql-packages.html" ><TT CLASS="LITERAL" >sql_packages</TT ></A ></DT ><DT >30.32. <A HREF="infoschema-sql-sizing.html" ><TT CLASS="LITERAL" >sql_sizing</TT ></A ></DT ><DT >30.33. <A HREF="infoschema-sql-sizing-profiles.html" ><TT CLASS="LITERAL" >sql_sizing_profiles</TT ></A ></DT ><DT >30.34. <A HREF="infoschema-table-constraints.html" ><TT CLASS="LITERAL" >table_constraints</TT ></A ></DT ><DT >30.35. <A HREF="infoschema-table-privileges.html" ><TT CLASS="LITERAL" >table_privileges</TT ></A ></DT ><DT >30.36. <A HREF="infoschema-tables.html" ><TT CLASS="LITERAL" >tables</TT ></A ></DT ><DT >30.37. <A HREF="infoschema-triggers.html" ><TT CLASS="LITERAL" >triggers</TT ></A ></DT ><DT >30.38. <A HREF="infoschema-usage-privileges.html" ><TT CLASS="LITERAL" >usage_privileges</TT ></A ></DT ><DT >30.39. <A HREF="infoschema-view-column-usage.html" ><TT CLASS="LITERAL" >view_column_usage</TT ></A ></DT ><DT >30.40. <A HREF="infoschema-view-table-usage.html" ><TT CLASS="LITERAL" >view_table_usage</TT ></A ></DT ><DT >30.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 >