Sophie: postgresql-docs-8.0.11-0.1.20060mdk x86

postgresql-docs-8.0.11-0.1.20060mdk.x86_64.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>PostgreSQL 8.0.11 Documentation</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="NEXT"
TITLE="Preface"
HREF="preface.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="BOOK"
><DIV
CLASS="BOOK"
><A
NAME="POSTGRES"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="TITLE"
><A
NAME="POSTGRES"
>PostgreSQL 8.0.11 Documentation</A
></H1
><H3
CLASS="CORPAUTHOR"
>The PostgreSQL Global Development Group</H3
><P
CLASS="COPYRIGHT"
><A
HREF="LEGALNOTICE.html"
>Copyright</A
> &copy; 1996-2005 The PostgreSQL Global Development Group</P
><HR></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
HREF="preface.html"
>Preface</A
></DT
><DD
><DL
><DT
><A
HREF="preface.html#INTRO-WHATIS"
>What is <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>?</A
></DT
><DT
><A
HREF="history.html"
>A Brief History of <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></A
></DT
><DT
><A
HREF="notation.html"
>Conventions</A
></DT
><DT
><A
HREF="resources.html"
>Further Information</A
></DT
><DT
><A
HREF="bug-reporting.html"
>Bug Reporting Guidelines</A
></DT
></DL
></DD
><DT
>I. <A
HREF="tutorial.html"
>Tutorial</A
></DT
><DD
><DL
><DT
>1. <A
HREF="tutorial-start.html"
>Getting Started</A
></DT
><DT
>2. <A
HREF="tutorial-sql.html"
>The <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Language</A
></DT
><DT
>3. <A
HREF="tutorial-advanced.html"
>Advanced Features</A
></DT
></DL
></DD
><DT
>II. <A
HREF="sql.html"
>The SQL Language</A
></DT
><DD
><DL
><DT
>4. <A
HREF="sql-syntax.html"
>SQL Syntax</A
></DT
><DT
>5. <A
HREF="ddl.html"
>Data Definition</A
></DT
><DT
>6. <A
HREF="dml.html"
>Data Manipulation</A
></DT
><DT
>7. <A
HREF="queries.html"
>Queries</A
></DT
><DT
>8. <A
HREF="datatype.html"
>Data Types</A
></DT
><DT
>9. <A
HREF="functions.html"
>Functions and Operators</A
></DT
><DT
>10. <A
HREF="typeconv.html"
>Type Conversion</A
></DT
><DT
>11. <A
HREF="indexes.html"
>Indexes</A
></DT
><DT
>12. <A
HREF="mvcc.html"
>Concurrency Control</A
></DT
><DT
>13. <A
HREF="performance-tips.html"
>Performance Tips</A
></DT
></DL
></DD
><DT
>III. <A
HREF="admin.html"
>Server Administration</A
></DT
><DD
><DL
><DT
>14. <A
HREF="installation.html"
>Installation Instructions</A
></DT
><DT
>15. <A
HREF="install-win32.html"
>Client-Only Installation on <SPAN
CLASS="PRODUCTNAME"
>Windows</SPAN
></A
></DT
><DT
>16. <A
HREF="runtime.html"
>Server Run-time Environment</A
></DT
><DT
>17. <A
HREF="user-manag.html"
>Database Users and Privileges</A
></DT
><DT
>18. <A
HREF="managing-databases.html"
>Managing Databases</A
></DT
><DT
>19. <A
HREF="client-authentication.html"
>Client Authentication</A
></DT
><DT
>20. <A
HREF="charset.html"
>Localization</A
></DT
><DT
>21. <A
HREF="maintenance.html"
>Routine Database Maintenance Tasks</A
></DT
><DT
>22. <A
HREF="backup.html"
>Backup and Restore</A
></DT
><DT
>23. <A
HREF="monitoring.html"
>Monitoring Database Activity</A
></DT
><DT
>24. <A
HREF="diskusage.html"
>Monitoring Disk Usage</A
></DT
><DT
>25. <A
HREF="wal.html"
>Write-Ahead Logging (<ACRONYM
CLASS="ACRONYM"
>WAL</ACRONYM
>)</A
></DT
><DT
>26. <A
HREF="regress.html"
>Regression Tests</A
></DT
></DL
></DD
><DT
>IV. <A
HREF="client-interfaces.html"
>Client Interfaces</A
></DT
><DD
><DL
><DT
>27. <A
HREF="libpq.html"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> - C Library</A
></DT
><DT
>28. <A
HREF="largeobjects.html"
>Large Objects</A
></DT
><DT
>29. <A
HREF="ecpg.html"
><SPAN
CLASS="APPLICATION"
>ECPG</SPAN
> - Embedded <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> in C</A
></DT
><DT
>30. <A
HREF="information-schema.html"
>The Information Schema</A
></DT
></DL
></DD
><DT
>V. <A
HREF="server-programming.html"
>Server Programming</A
></DT
><DD
><DL
><DT
>31. <A
HREF="extend.html"
>Extending <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
></A
></DT
><DT
>32. <A
HREF="triggers.html"
>Triggers</A
></DT
><DT
>33. <A
HREF="rules.html"
>The Rule System</A
></DT
><DT
>34. <A
HREF="xplang.html"
>Procedural Languages</A
></DT
><DT
>35. <A
HREF="plpgsql.html"
><SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
> - <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Procedural Language</A
></DT
><DT
>36. <A
HREF="pltcl.html"
>PL/Tcl - Tcl Procedural Language</A
></DT
><DT
>37. <A
HREF="plperl.html"
>PL/Perl - Perl Procedural Language</A
></DT
><DT
>38. <A
HREF="plpython.html"
>PL/Python - Python Procedural Language</A
></DT
><DT
>39. <A
HREF="spi.html"
>Server Programming Interface</A
></DT
></DL
></DD
><DT
>VI. <A
HREF="reference.html"
>Reference</A
></DT
><DD
><DL
><DT
>I. <A
HREF="sql-commands.html"
>SQL Commands</A
></DT
><DT
>II. <A
HREF="reference-client.html"
>PostgreSQL Client Applications</A
></DT
><DT
>III. <A
HREF="reference-server.html"
>PostgreSQL Server Applications</A
></DT
></DL
></DD
><DT
>VII. <A
HREF="internals.html"
>Internals</A
></DT
><DD
><DL
><DT
>40. <A
HREF="overview.html"
>Overview of PostgreSQL Internals</A
></DT
><DT
>41. <A
HREF="catalogs.html"
>System Catalogs</A
></DT
><DT
>42. <A
HREF="protocol.html"
>Frontend/Backend Protocol</A
></DT
><DT
>43. <A
HREF="source.html"
>PostgreSQL Coding Conventions</A
></DT
><DT
>44. <A
HREF="nls.html"
>Native Language Support</A
></DT
><DT
>45. <A
HREF="plhandler.html"
>Writing A Procedural Language Handler</A
></DT
><DT
>46. <A
HREF="geqo.html"
>Genetic Query Optimizer</A
></DT
><DT
>47. <A
HREF="indexcost.html"
>Index Cost Estimation Functions</A
></DT
><DT
>48. <A
HREF="gist.html"
>GiST Indexes</A
></DT
><DT
>49. <A
HREF="storage.html"
>Database Physical Storage</A
></DT
><DT
>50. <A
HREF="bki.html"
><ACRONYM
CLASS="ACRONYM"
>BKI</ACRONYM
> Backend Interface</A
></DT
></DL
></DD
><DT
>VIII. <A
HREF="appendixes.html"
>Appendixes</A
></DT
><DD
><DL
><DT
>A. <A
HREF="errcodes-appendix.html"
><SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> Error Codes</A
></DT
><DT
>B. <A
HREF="datetime-appendix.html"
>Date/Time Support</A
></DT
><DT
>C. <A
HREF="sql-keywords-appendix.html"
><ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Key Words</A
></DT
><DT
>D. <A
HREF="features.html"
>SQL Conformance</A
></DT
><DT
>E. <A
HREF="release.html"
>Release Notes</A
></DT
><DT
>F. <A
HREF="cvs.html"
>The <SPAN
CLASS="PRODUCTNAME"
>CVS</SPAN
> Repository</A
></DT
><DT
>G. <A
HREF="docguide.html"
>Documentation</A
></DT
><DT
>H. <A
HREF="external-projects.html"
>External Projects</A
></DT
></DL
></DD
><DT
><A
HREF="biblio.html"
>Bibliography</A
></DT
><DT
><A
HREF="bookindex.html"
>Index</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Tables</B
></DT
><DT
>4-1. <A
HREF="sql-syntax.html#SQL-PRECEDENCE-TABLE"
>Operator Precedence (decreasing)</A
></DT
><DT
>8-1. <A
HREF="datatype.html#DATATYPE-TABLE"
>Data Types</A
></DT
><DT
>8-2. <A
HREF="datatype.html#DATATYPE-NUMERIC-TABLE"
>Numeric Types</A
></DT
><DT
>8-3. <A
HREF="datatype-money.html#DATATYPE-MONEY-TABLE"
>Monetary Types</A
></DT
><DT
>8-4. <A
HREF="datatype-character.html#DATATYPE-CHARACTER-TABLE"
>Character Types</A
></DT
><DT
>8-5. <A
HREF="datatype-character.html#DATATYPE-CHARACTER-SPECIAL-TABLE"
>Special Character Types</A
></DT
><DT
>8-6. <A
HREF="datatype-binary.html#DATATYPE-BINARY-TABLE"
>Binary Data Types</A
></DT
><DT
>8-7. <A
HREF="datatype-binary.html#DATATYPE-BINARY-SQLESC"
><TT
CLASS="TYPE"
>bytea</TT
> Literal Escaped Octets</A
></DT
><DT
>8-8. <A
HREF="datatype-binary.html#DATATYPE-BINARY-RESESC"
><TT
CLASS="TYPE"
>bytea</TT
> Output Escaped Octets</A
></DT
><DT
>8-9. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-TABLE"
>Date/Time Types</A
></DT
><DT
>8-10. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-DATE-TABLE"
>Date Input</A
></DT
><DT
>8-11. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-TIME-TABLE"
>Time Input</A
></DT
><DT
>8-12. <A
HREF="datatype-datetime.html#DATATYPE-TIMEZONE-TABLE"
>Time Zone Input</A
></DT
><DT
>8-13. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-SPECIAL-TABLE"
>Special Date/Time Inputs</A
></DT
><DT
>8-14. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT-TABLE"
>Date/Time Output Styles</A
></DT
><DT
>8-15. <A
HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT2-TABLE"
>Date Order Conventions</A
></DT
><DT
>8-16. <A
HREF="datatype-geometric.html#DATATYPE-GEO-TABLE"
>Geometric Types</A
></DT
><DT
>8-17. <A
HREF="datatype-net-types.html#DATATYPE-NET-TYPES-TABLE"
>Network Address Types</A
></DT
><DT
>8-18. <A
HREF="datatype-net-types.html#DATATYPE-NET-CIDR-TABLE"
><TT
CLASS="TYPE"
>cidr</TT
> Type Input Examples</A
></DT
><DT
>8-19. <A
HREF="datatype-oid.html#DATATYPE-OID-TABLE"
>Object Identifier Types</A
></DT
><DT
>8-20. <A
HREF="datatype-pseudo.html#DATATYPE-PSEUDOTYPES-TABLE"
>Pseudo-Types</A
></DT
><DT
>9-1. <A
HREF="functions-comparison.html#FUNCTIONS-COMPARISON-TABLE"
>Comparison Operators</A
></DT
><DT
>9-2. <A
HREF="functions-math.html#FUNCTIONS-MATH-OP-TABLE"
>Mathematical Operators</A
></DT
><DT
>9-3. <A
HREF="functions-math.html#FUNCTIONS-MATH-FUNC-TABLE"
>Mathematical Functions</A
></DT
><DT
>9-4. <A
HREF="functions-math.html#FUNCTIONS-MATH-TRIG-TABLE"
>Trigonometric Functions</A
></DT
><DT
>9-5. <A
HREF="functions-string.html#FUNCTIONS-STRING-SQL"
><ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> String Functions and Operators</A
></DT
><DT
>9-6. <A
HREF="functions-string.html#FUNCTIONS-STRING-OTHER"
>Other String Functions</A
></DT
><DT
>9-7. <A
HREF="functions-string.html#CONVERSION-NAMES"
>Built-in Conversions</A
></DT
><DT
>9-8. <A
HREF="functions-binarystring.html#FUNCTIONS-BINARYSTRING-SQL"
><ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Binary String Functions and Operators</A
></DT
><DT
>9-9. <A
HREF="functions-binarystring.html#FUNCTIONS-BINARYSTRING-OTHER"
>Other Binary String Functions</A
></DT
><DT
>9-10. <A
HREF="functions-bitstring.html#FUNCTIONS-BIT-STRING-OP-TABLE"
>Bit String Operators</A
></DT
><DT
>9-11. <A
HREF="functions-matching.html#FUNCTIONS-POSIX-TABLE"
>Regular Expression Match Operators</A
></DT
><DT
>9-12. <A
HREF="functions-matching.html#POSIX-ATOMS-TABLE"
>Regular Expression Atoms</A
></DT
><DT
>9-13. <A
HREF="functions-matching.html#POSIX-QUANTIFIERS-TABLE"
>Regular Expression Quantifiers</A
></DT
><DT
>9-14. <A
HREF="functions-matching.html#POSIX-CONSTRAINTS-TABLE"
>Regular Expression Constraints</A
></DT
><DT
>9-15. <A
HREF="functions-matching.html#POSIX-CHARACTER-ENTRY-ESCAPES-TABLE"
>Regular Expression Character-Entry Escapes</A
></DT
><DT
>9-16. <A
HREF="functions-matching.html#POSIX-CLASS-SHORTHAND-ESCAPES-TABLE"
>Regular Expression Class-Shorthand Escapes</A
></DT
><DT
>9-17. <A
HREF="functions-matching.html#POSIX-CONSTRAINT-ESCAPES-TABLE"
>Regular Expression Constraint Escapes</A
></DT
><DT
>9-18. <A
HREF="functions-matching.html#POSIX-CONSTRAINT-BACKREF-TABLE"
>Regular Expression Back References</A
></DT
><DT
>9-19. <A
HREF="functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE"
>ARE Embedded-Option Letters</A
></DT
><DT
>9-20. <A
HREF="functions-formatting.html#FUNCTIONS-FORMATTING-TABLE"
>Formatting Functions</A
></DT
><DT
>9-21. <A
HREF="functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE"
>Template Patterns for Date/Time Formatting</A
></DT
><DT
>9-22. <A
HREF="functions-formatting.html#FUNCTIONS-FORMATTING-DATETIMEMOD-TABLE"
>Template Pattern Modifiers for Date/Time Formatting</A
></DT
><DT
>9-23. <A
HREF="functions-formatting.html#FUNCTIONS-FORMATTING-NUMERIC-TABLE"
>Template Patterns for Numeric Formatting</A
></DT
><DT
>9-24. <A
HREF="functions-formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE"
><CODE
CLASS="FUNCTION"
>to_char</CODE
> Examples</A
></DT
><DT
>9-25. <A
HREF="functions-datetime.html#OPERATORS-DATETIME-TABLE"
>Date/Time Operators</A
></DT
><DT
>9-26. <A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-TABLE"
>Date/Time Functions</A
></DT
><DT
>9-27. <A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT-TABLE"
><TT
CLASS="LITERAL"
>AT TIME ZONE</TT
> Variants</A
></DT
><DT
>9-28. <A
HREF="functions-geometry.html#FUNCTIONS-GEOMETRY-OP-TABLE"
>Geometric Operators</A
></DT
><DT
>9-29. <A
HREF="functions-geometry.html#FUNCTIONS-GEOMETRY-FUNC-TABLE"
>Geometric Functions</A
></DT
><DT
>9-30. <A
HREF="functions-geometry.html#FUNCTIONS-GEOMETRY-CONV-TABLE"
>Geometric Type Conversion Functions</A
></DT
><DT
>9-31. <A
HREF="functions-net.html#CIDR-INET-OPERATORS-TABLE"
><TT
CLASS="TYPE"
>cidr</TT
> and <TT
CLASS="TYPE"
>inet</TT
> Operators</A
></DT
><DT
>9-32. <A
HREF="functions-net.html#CIDR-INET-FUNCTIONS-TABLE"
><TT
CLASS="TYPE"
>cidr</TT
> and <TT
CLASS="TYPE"
>inet</TT
> Functions</A
></DT
><DT
>9-33. <A
HREF="functions-net.html#MACADDR-FUNCTIONS-TABLE"
><TT
CLASS="TYPE"
>macaddr</TT
> Functions</A
></DT
><DT
>9-34. <A
HREF="functions-sequence.html#FUNCTIONS-SEQUENCE-TABLE"
>Sequence Functions</A
></DT
><DT
>9-35. <A
HREF="functions-array.html#ARRAY-OPERATORS-TABLE"
><TT
CLASS="TYPE"
>array</TT
> Operators</A
></DT
><DT
>9-36. <A
HREF="functions-array.html#ARRAY-FUNCTIONS-TABLE"
><TT
CLASS="TYPE"
>array</TT
> Functions</A
></DT
><DT
>9-37. <A
HREF="functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE"
>Aggregate Functions</A
></DT
><DT
>9-38. <A
HREF="functions-srf.html#FUNCTIONS-SRF-SERIES"
>Series Generating Functions</A
></DT
><DT
>9-39. <A
HREF="functions-info.html#FUNCTIONS-INFO-SESSION-TABLE"
>Session Information Functions</A
></DT
><DT
>9-40. <A
HREF="functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE"
>Access Privilege Inquiry Functions</A
></DT
><DT
>9-41. <A
HREF="functions-info.html#FUNCTIONS-INFO-SCHEMA-TABLE"
>Schema Visibility Inquiry Functions</A
></DT
><DT
>9-42. <A
HREF="functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE"
>System Catalog Information Functions</A
></DT
><DT
>9-43. <A
HREF="functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE"
>Comment Information Functions</A
></DT
><DT
>9-44. <A
HREF="functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE"
>Configuration Settings Functions</A
></DT
><DT
>9-45. <A
HREF="functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE"
>Backend Signalling Functions</A
></DT
><DT
>9-46. <A
HREF="functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE"
>Backup Control Functions</A
></DT
><DT
>12-1. <A
HREF="transaction-iso.html#MVCC-ISOLEVEL-TABLE"
><ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Transaction Isolation Levels</A
></DT
><DT
>16-1. <A
HREF="runtime-config.html#RUNTIME-CONFIG-SHORT-TABLE"
>Short option key</A
></DT
><DT
>16-2. <A
HREF="kernel-resources.html#SYSVIPC-PARAMETERS"
><SPAN
CLASS="SYSTEMITEM"
>System V</SPAN
> <ACRONYM
CLASS="ACRONYM"
>IPC</ACRONYM
> parameters</A
></DT
><DT
>20-1. <A
HREF="multibyte.html#CHARSET-TABLE"
>Server Character Sets</A
></DT
><DT
>20-2. <A
HREF="multibyte.html#MULTIBYTE-TRANSLATION-TABLE"
>Client/Server Character Set Conversions</A
></DT
><DT
>23-1. <A
HREF="monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE"
>Standard Statistics Views</A
></DT
><DT
>23-2. <A
HREF="monitoring-stats.html#MONITORING-STATS-FUNCS-TABLE"
>Statistics Access Functions</A
></DT
><DT
>30-1. <A
HREF="infoschema-information-schema-catalog-name.html#AEN25981"
><TT
CLASS="LITERAL"
>information_schema_catalog_name</TT
> Columns</A
></DT
><DT
>30-2. <A
HREF="infoschema-applicable-roles.html#AEN26003"
><TT
CLASS="LITERAL"
>applicable_roles</TT
> Columns</A
></DT
><DT
>30-3. <A
HREF="infoschema-check-constraints.html#AEN26037"
><TT
CLASS="LITERAL"
>check_constraints</TT
> Columns</A
></DT
><DT
>30-4. <A
HREF="infoschema-column-domain-usage.html#AEN26076"
><TT
CLASS="LITERAL"
>column_domain_usage</TT
> Columns</A
></DT
><DT
>30-5. <A
HREF="infoschema-column-privileges.html#AEN26142"
><TT
CLASS="LITERAL"
>column_privileges</TT
> Columns</A
></DT
><DT
>30-6. <A
HREF="infoschema-column-udt-usage.html#AEN26216"
><TT
CLASS="LITERAL"
>column_udt_usage</TT
> Columns</A
></DT
><DT
>30-7. <A
HREF="infoschema-columns.html#AEN26274"
><TT
CLASS="LITERAL"
>columns</TT
> Columns</A
></DT
><DT
>30-8. <A
HREF="infoschema-constraint-column-usage.html#AEN26535"
><TT
CLASS="LITERAL"
>constraint_column_usage</TT
> Columns</A
></DT
><DT
>30-9. <A
HREF="infoschema-constraint-table-usage.html#AEN26593"
><TT
CLASS="LITERAL"
>constraint_table_usage</TT
> Columns</A
></DT
><DT
>30-10. <A
HREF="infoschema-data-type-privileges.html#AEN26644"
><TT
CLASS="LITERAL"
>data_type_privileges</TT
> Columns</A
></DT
><DT
>30-11. <A
HREF="infoschema-domain-constraints.html#AEN26692"
><TT
CLASS="LITERAL"
>domain_constraints</TT
> Columns</A
></DT
><DT
>30-12. <A
HREF="infoschema-domain-udt-usage.html#AEN26760"
><TT
CLASS="LITERAL"
>domain_udt_usage</TT
> Columns</A
></DT
><DT
>30-13. <A
HREF="infoschema-domains.html#AEN26811"
><TT
CLASS="LITERAL"
>domains</TT
> Columns</A
></DT
><DT
>30-14. <A
HREF="infoschema-element-types.html#AEN27010"
><TT
CLASS="LITERAL"
>element_types</TT
> Columns</A
></DT
><DT
>30-15. <A
HREF="infoschema-enabled-roles.html#AEN27224"
><TT
CLASS="LITERAL"
>enabled_roles</TT
> Columns</A
></DT
><DT
>30-16. <A
HREF="infoschema-key-column-usage.html#AEN27245"
><TT
CLASS="LITERAL"
>key_column_usage</TT
> Columns</A
></DT
><DT
>30-17. <A
HREF="infoschema-parameters.html#AEN27308"
><TT
CLASS="LITERAL"
>parameters</TT
> Columns</A
></DT
><DT
>30-18. <A
HREF="infoschema-referential-constraints.html#AEN27536"
><TT
CLASS="LITERAL"
>referential_constraints</TT
> Columns</A
></DT
><DT
>30-19. <A
HREF="infoschema-role-column-grants.html#AEN27619"
><TT
CLASS="LITERAL"
>role_column_grants</TT
> Columns</A
></DT
><DT
>30-20. <A
HREF="infoschema-role-routine-grants.html#AEN27689"
><TT
CLASS="LITERAL"
>role_routine_grants</TT
> Columns</A
></DT
><DT
>30-21. <A
HREF="infoschema-role-table-grants.html#AEN27770"
><TT
CLASS="LITERAL"
>role_table_grants</TT
> Columns</A
></DT
><DT
>30-22. <A
HREF="infoschema-role-usage-grants.html#AEN27847"
><TT
CLASS="LITERAL"
>role_usage_grants</TT
> Columns</A
></DT
><DT
>30-23. <A
HREF="infoschema-routine-privileges.html#AEN27914"
><TT
CLASS="LITERAL"
>routine_privileges</TT
> Columns</A
></DT
><DT
>30-24. <A
HREF="infoschema-routines.html#AEN27997"
><TT
CLASS="LITERAL"
>routines</TT
> Columns</A
></DT
><DT
>30-25. <A
HREF="infoschema-schemata.html#AEN28393"
><TT
CLASS="LITERAL"
>schemata</TT
> Columns</A
></DT
><DT
>30-26. <A
HREF="infoschema-sql-features.html#AEN28456"
><TT
CLASS="LITERAL"
>sql_features</TT
> Columns</A
></DT
><DT
>30-27. <A
HREF="infoschema-sql-implementation-info.html#AEN28517"
><TT
CLASS="LITERAL"
>sql_implementation_info</TT
> Columns</A
></DT
><DT
>30-28. <A
HREF="infoschema-sql-languages.html#AEN28566"
><TT
CLASS="LITERAL"
>sql_languages</TT
> Columns</A
></DT
><DT
>30-29. <A
HREF="infoschema-sql-packages.html#AEN28633"
><TT
CLASS="LITERAL"
>sql_packages</TT
> Columns</A
></DT
><DT
>30-30. <A
HREF="infoschema-sql-sizing.html#AEN28683"
><TT
CLASS="LITERAL"
>sql_sizing</TT
> Columns</A
></DT
><DT
>30-31. <A
HREF="infoschema-sql-sizing-profiles.html#AEN28724"
><TT
CLASS="LITERAL"
>sql_sizing_profiles</TT
> Columns</A
></DT
><DT
>30-32. <A
HREF="infoschema-table-constraints.html#AEN28769"
><TT
CLASS="LITERAL"
>table_constraints</TT
> Columns</A
></DT
><DT
>30-33. <A
HREF="infoschema-table-privileges.html#AEN28847"
><TT
CLASS="LITERAL"
>table_privileges</TT
> Columns</A
></DT
><DT
>30-34. <A
HREF="infoschema-tables.html#AEN28923"
><TT
CLASS="LITERAL"
>tables</TT
> Columns</A
></DT
><DT
>30-35. <A
HREF="infoschema-triggers.html#AEN29000"
><TT
CLASS="LITERAL"
>triggers</TT
> Columns</A
></DT
><DT
>30-36. <A
HREF="infoschema-usage-privileges.html#AEN29126"
><TT
CLASS="LITERAL"
>usage_privileges</TT
> Columns</A
></DT
><DT
>30-37. <A
HREF="infoschema-view-column-usage.html#AEN29196"
><TT
CLASS="LITERAL"
>view_column_usage</TT
> Columns</A
></DT
><DT
>30-38. <A
HREF="infoschema-view-table-usage.html#AEN29256"
><TT
CLASS="LITERAL"
>view_table_usage</TT
> Columns</A
></DT
><DT
>30-39. <A
HREF="infoschema-views.html#AEN29307"
><TT
CLASS="LITERAL"
>views</TT
> Columns</A
></DT
><DT
>31-1. <A
HREF="xfunc-c.html#XFUNC-C-TYPE-TABLE"
>Equivalent C Types for Built-In SQL Types</A
></DT
><DT
>31-2. <A
HREF="xindex.html#XINDEX-BTREE-STRAT-TABLE"
>B-tree Strategies</A
></DT
><DT
>31-3. <A
HREF="xindex.html#XINDEX-HASH-STRAT-TABLE"
>Hash Strategies</A
></DT
><DT
>31-4. <A
HREF="xindex.html#XINDEX-RTREE-STRAT-TABLE"
>R-tree Strategies</A
></DT
><DT
>31-5. <A
HREF="xindex.html#XINDEX-BTREE-SUPPORT-TABLE"
>B-tree Support Functions</A
></DT
><DT
>31-6. <A
HREF="xindex.html#XINDEX-HASH-SUPPORT-TABLE"
>Hash Support Functions</A
></DT
><DT
>31-7. <A
HREF="xindex.html#XINDEX-RTREE-SUPPORT-TABLE"
>R-tree Support Functions</A
></DT
><DT
>31-8. <A
HREF="xindex.html#XINDEX-GIST-SUPPORT-TABLE"
>GiST Support Functions</A
></DT
><DT
>41-1. <A
HREF="catalogs.html#CATALOG-TABLE"
>System Catalogs</A
></DT
><DT
>41-2. <A
HREF="catalog-pg-aggregate.html#AEN52007"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
> Columns</A
></DT
><DT
>41-3. <A
HREF="catalog-pg-am.html#AEN52076"
><TT
CLASS="STRUCTNAME"
>pg_am</TT
> Columns</A
></DT
><DT
>41-4. <A
HREF="catalog-pg-amop.html#AEN52286"
><TT
CLASS="STRUCTNAME"
>pg_amop</TT
> Columns</A
></DT
><DT
>41-5. <A
HREF="catalog-pg-amproc.html#AEN52348"
><TT
CLASS="STRUCTNAME"
>pg_amproc</TT
> Columns</A
></DT
><DT
>41-6. <A
HREF="catalog-pg-attrdef.html#AEN52404"
><TT
CLASS="STRUCTNAME"
>pg_attrdef</TT
> Columns</A
></DT
><DT
>41-7. <A
HREF="catalog-pg-attribute.html#AEN52463"
><TT
CLASS="STRUCTNAME"
>pg_attribute</TT
> Columns</A
></DT
><DT
>41-8. <A
HREF="catalog-pg-cast.html#AEN52628"
><TT
CLASS="STRUCTFIELD"
>pg_cast</TT
> Columns</A
></DT
><DT
>41-9. <A
HREF="catalog-pg-class.html#AEN52703"
><TT
CLASS="STRUCTNAME"
>pg_class</TT
> Columns</A
></DT
><DT
>41-10. <A
HREF="catalog-pg-constraint.html#AEN52949"
><TT
CLASS="STRUCTNAME"
>pg_constraint</TT
> Columns</A
></DT
><DT
>41-11. <A
HREF="catalog-pg-conversion.html#AEN53102"
><TT
CLASS="STRUCTNAME"
>pg_conversion</TT
> Columns</A
></DT
><DT
>41-12. <A
HREF="catalog-pg-database.html#AEN53183"
><TT
CLASS="STRUCTNAME"
>pg_database</TT
> Columns</A
></DT
><DT
>41-13. <A
HREF="catalog-pg-depend.html#AEN53296"
><TT
CLASS="STRUCTNAME"
>pg_depend</TT
> Columns</A
></DT
><DT
>41-14. <A
HREF="catalog-pg-description.html#AEN53414"
><TT
CLASS="STRUCTNAME"
>pg_description</TT
> Columns</A
></DT
><DT
>41-15. <A
HREF="catalog-pg-group.html#AEN53470"
><TT
CLASS="STRUCTNAME"
>pg_group</TT
> Columns</A
></DT
><DT
>41-16. <A
HREF="catalog-pg-index.html#AEN53513"
><TT
CLASS="STRUCTNAME"
>pg_index</TT
> Columns</A
></DT
><DT
>41-17. <A
HREF="catalog-pg-inherits.html#AEN53624"
><TT
CLASS="STRUCTNAME"
>pg_inherits</TT
> Columns</A
></DT
><DT
>41-18. <A
HREF="catalog-pg-language.html#AEN53671"
><TT
CLASS="STRUCTNAME"
>pg_language</TT
> Columns</A
></DT
><DT
>41-19. <A
HREF="catalog-pg-largeobject.html#AEN53747"
><TT
CLASS="STRUCTNAME"
>pg_largeobject</TT
> Columns</A
></DT
><DT
>41-20. <A
HREF="catalog-pg-listener.html#AEN53795"
><TT
CLASS="STRUCTNAME"
>pg_listener</TT
> Columns</A
></DT
><DT
>41-21. <A
HREF="catalog-pg-namespace.html#AEN53835"
><TT
CLASS="STRUCTNAME"
>pg_namespace</TT
> Columns</A
></DT
><DT
>41-22. <A
HREF="catalog-pg-opclass.html#AEN53881"
><TT
CLASS="STRUCTNAME"
>pg_opclass</TT
> Columns</A
></DT
><DT
>41-23. <A
HREF="catalog-pg-operator.html#AEN53973"
><TT
CLASS="STRUCTNAME"
>pg_operator</TT
> Columns</A
></DT
><DT
>41-24. <A
HREF="catalog-pg-proc.html#AEN54169"
><TT
CLASS="STRUCTNAME"
>pg_proc</TT
> Columns</A
></DT
><DT
>41-25. <A
HREF="catalog-pg-rewrite.html#AEN54330"
><TT
CLASS="STRUCTNAME"
>pg_rewrite</TT
> Columns</A
></DT
><DT
>41-26. <A
HREF="catalog-pg-shadow.html#AEN54418"
><TT
CLASS="STRUCTNAME"
>pg_shadow</TT
> Columns</A
></DT
><DT
>41-27. <A
HREF="catalog-pg-statistic.html#AEN54506"
><TT
CLASS="STRUCTNAME"
>pg_statistic</TT
> Columns</A
></DT
><DT
>41-28. <A
HREF="catalog-pg-tablespace.html#AEN54615"
><TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
> Columns</A
></DT
><DT
>41-29. <A
HREF="catalog-pg-trigger.html#AEN54667"
><TT
CLASS="STRUCTNAME"
>pg_trigger</TT
> Columns</A
></DT
><DT
>41-30. <A
HREF="catalog-pg-type.html#AEN54791"
><TT
CLASS="STRUCTNAME"
>pg_type</TT
> Columns</A
></DT
><DT
>41-31. <A
HREF="views-overview.html#VIEW-TABLE"
>System Views</A
></DT
><DT
>41-32. <A
HREF="view-pg-indexes.html#AEN55161"
><TT
CLASS="STRUCTNAME"
>pg_indexes</TT
> Columns</A
></DT
><DT
>41-33. <A
HREF="view-pg-locks.html#AEN55230"
><TT
CLASS="STRUCTNAME"
>pg_locks</TT
> Columns</A
></DT
><DT
>41-34. <A
HREF="view-pg-rules.html#AEN55312"
><TT
CLASS="STRUCTNAME"
>pg_rules</TT
> Columns</A
></DT
><DT
>41-35. <A
HREF="view-pg-settings.html#AEN55373"
><TT
CLASS="STRUCTNAME"
>pg_settings</TT
> Columns</A
></DT
><DT
>41-36. <A
HREF="view-pg-stats.html#AEN55480"
><TT
CLASS="STRUCTNAME"
>pg_stats</TT
> Columns</A
></DT
><DT
>41-37. <A
HREF="view-pg-tables.html#AEN55588"
><TT
CLASS="STRUCTNAME"
>pg_tables</TT
> Columns</A
></DT
><DT
>41-38. <A
HREF="view-pg-user.html#AEN55678"
><TT
CLASS="STRUCTNAME"
>pg_user</TT
> Columns</A
></DT
><DT
>41-39. <A
HREF="view-pg-views.html#AEN55753"
><TT
CLASS="STRUCTNAME"
>pg_views</TT
> Columns</A
></DT
><DT
>49-1. <A
HREF="storage.html#PGDATA-CONTENTS-TABLE"
>Contents of <TT
CLASS="VARNAME"
>PGDATA</TT
></A
></DT
><DT
>49-2. <A
HREF="storage-page-layout.html#PAGE-TABLE"
>Overall Page Layout</A
></DT
><DT
>49-3. <A
HREF="storage-page-layout.html#PAGEHEADERDATA-TABLE"
>PageHeaderData Layout</A
></DT
><DT
>49-4. <A
HREF="storage-page-layout.html#HEAPTUPLEHEADERDATA-TABLE"
>HeapTupleHeaderData Layout</A
></DT
><DT
>A-1. <A
HREF="errcodes-appendix.html#ERRCODES-TABLE"
><SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> Error Codes</A
></DT
><DT
>B-1. <A
HREF="datetime-keywords.html#DATETIME-MONTH-TABLE"
>Month Names</A
></DT
><DT
>B-2. <A
HREF="datetime-keywords.html#DATETIME-DOW-TABLE"
>Day of the Week Names</A
></DT
><DT
>B-3. <A
HREF="datetime-keywords.html#DATETIME-MOD-TABLE"
>Date/Time Field Modifiers</A
></DT
><DT
>B-4. <A
HREF="datetime-keywords.html#DATETIME-TIMEZONE-INPUT-TABLE"
>Time Zone Abbreviations for Input</A
></DT
><DT
>B-5. <A
HREF="datetime-keywords.html#DATETIME-OZTZ-TABLE"
>Australian Time Zone Abbreviations for Input</A
></DT
><DT
>B-6. <A
HREF="datetime-keywords.html#DATETIME-TIMEZONE-SET-TABLE"
>Time Zone Names for Setting <TT
CLASS="VARNAME"
>timezone</TT
></A
></DT
><DT
>C-1. <A
HREF="sql-keywords-appendix.html#KEYWORDS-TABLE"
><ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Key Words</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Figures</B
></DT
><DT
>46-1. <A
HREF="geqo-intro2.html#GEQO-DIAGRAM"
>Structured Diagram of a Genetic Algorithm</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Examples</B
></DT
><DT
>8-1. <A
HREF="datatype-character.html#AEN4000"
>Using the character types</A
></DT
><DT
>8-2. <A
HREF="datatype-boolean.html#DATATYPE-BOOLEAN-EXAMPLE"
>Using the <TT
CLASS="TYPE"
>boolean</TT
> type</A
></DT
><DT
>8-3. <A
HREF="datatype-bit.html#AEN5357"
>Using the bit string types</A
></DT
><DT
>10-1. <A
HREF="typeconv-oper.html#AEN13819"
>Exponentiation Operator Type Resolution</A
></DT
><DT
>10-2. <A
HREF="typeconv-oper.html#AEN13826"
>String Concatenation Operator Type Resolution</A
></DT
><DT
>10-3. <A
HREF="typeconv-oper.html#AEN13838"
>Absolute-Value and Negation Operator Type Resolution</A
></DT
><DT
>10-4. <A
HREF="typeconv-func.html#AEN13895"
>Rounding Function Argument Type Resolution</A
></DT
><DT
>10-5. <A
HREF="typeconv-func.html#AEN13908"
>Substring Function Type Resolution</A
></DT
><DT
>10-6. <A
HREF="typeconv-query.html#AEN13950"
><TT
CLASS="TYPE"
>character</TT
> Storage Type Conversion</A
></DT
><DT
>10-7. <A
HREF="typeconv-union-case.html#AEN14005"
>Type Resolution with Underspecified Types in a Union</A
></DT
><DT
>10-8. <A
HREF="typeconv-union-case.html#AEN14011"
>Type Resolution in a Simple Union</A
></DT
><DT
>10-9. <A
HREF="typeconv-union-case.html#AEN14020"
>Type Resolution in a Transposed Union</A
></DT
><DT
>11-1. <A
HREF="indexes-partial.html#INDEXES-PARTIAL-EX1"
>Setting up a Partial Index to Exclude Common Values</A
></DT
><DT
>11-2. <A
HREF="indexes-partial.html#INDEXES-PARTIAL-EX2"
>Setting up a Partial Index to Exclude Uninteresting Values</A
></DT
><DT
>11-3. <A
HREF="indexes-partial.html#INDEXES-PARTIAL-EX3"
>Setting up a Partial Unique Index</A
></DT
><DT
>19-1. <A
HREF="client-authentication.html#EXAMPLE-PG-HBA.CONF"
>Example <TT
CLASS="FILENAME"
>pg_hba.conf</TT
> entries</A
></DT
><DT
>19-2. <A
HREF="auth-methods.html#EXAMPLE-PG-IDENT.CONF"
>An example <TT
CLASS="FILENAME"
>pg_ident.conf</TT
> file</A
></DT
><DT
>27-1. <A
HREF="libpq-example.html#LIBPQ-EXAMPLE-1"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> Example Program 1</A
></DT
><DT
>27-2. <A
HREF="libpq-example.html#LIBPQ-EXAMPLE-2"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> Example Program 2</A
></DT
><DT
>27-3. <A
HREF="libpq-example.html#LIBPQ-EXAMPLE-3"
><SPAN
CLASS="APPLICATION"
>libpq</SPAN
> Example Program 3</A
></DT
><DT
>28-1. <A
HREF="lo-examplesect.html#LO-EXAMPLE"
>Large Objects with <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> Example Program</A
></DT
><DT
>34-1. <A
HREF="xplang.html#XPLANG-INSTALL-EXAMPLE"
>Manual Installation of <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
></A
></DT
><DT
>35-1. <A
HREF="plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE"
>Exceptions with <TT
CLASS="COMMAND"
>UPDATE</TT
>/<TT
CLASS="COMMAND"
>INSERT</TT
></A
></DT
><DT
>35-2. <A
HREF="plpgsql-trigger.html#PLPGSQL-TRIGGER-EXAMPLE"
>A <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
> Trigger Procedure</A
></DT
><DT
>35-3. <A
HREF="plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE"
>A <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
> Trigger Procedure For Auditing</A
></DT
><DT
>35-4. <A
HREF="plpgsql-trigger.html#PLPGSQL-TRIGGER-SUMMARY-EXAMPLE"
>A <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
> Trigger Procedure For Maintaining A Summary Table</A
></DT
><DT
>35-5. <A
HREF="plpgsql-porting.html#PGSQL-PORTING-EX1"
>Porting a Simple Function from <SPAN
CLASS="APPLICATION"
>PL/SQL</SPAN
> to <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
></A
></DT
><DT
>35-6. <A
HREF="plpgsql-porting.html#PLPGSQL-PORTING-EX2"
>Porting a Function that Creates Another Function from <SPAN
CLASS="APPLICATION"
>PL/SQL</SPAN
> to <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
></A
></DT
><DT
>35-7. <A
HREF="plpgsql-porting.html#PLPGSQL-PORTING-EX3"
>Porting a Procedure With String Manipulation and
    <TT
CLASS="LITERAL"
>OUT</TT
> Parameters from <SPAN
CLASS="APPLICATION"
>PL/SQL</SPAN
> to
    <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
></A
></DT
><DT
>35-8. <A
HREF="plpgsql-porting.html#PLPGSQL-PORTING-EX4"
>Porting a Procedure from <SPAN
CLASS="APPLICATION"
>PL/SQL</SPAN
> to <SPAN
CLASS="APPLICATION"
>PL/pgSQL</SPAN
></A
></DT
></DL
></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"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="preface.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Preface</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>