Sophie: postgresql-tcl-8.1.23-10.el5_10 x86

postgresql-tcl-8.1.23-10.el5_10.x86_64.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>Pgtcl Reference Manual</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="NEXT"
TITLE="Preface"
HREF="pgtcl-preface.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
NAME="creation"
CONTENT="2004-11-09T00:53:06"></HEAD
><BODY
CLASS="BOOK"
><DIV
CLASS="BOOK"
><A
NAME="PGTCL"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="TITLE"
><A
NAME="AEN2"
>Pgtcl Reference Manual</A
></H1
><H2
CLASS="SUBTITLE"
>The PostgreSQL Tcl Interface</H2
><P
CLASS="COPYRIGHT"
><A
HREF="LEGALNOTICE.html"
>Copyright</A
> &copy; 1996-2004 The PostgreSQL Global Development Group and others</P
><P
CLASS="PUBDATE"
>2004-11-08<BR></P
><HR></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
HREF="pgtcl-preface.html"
>Preface</A
></DT
><DT
>1. <A
HREF="pgtcl-overview.html"
>Overview</A
></DT
><DT
>2. <A
HREF="pgtcl-make.html"
>Building and Installing <SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
></A
></DT
><DD
><DL
><DT
>2.1. <A
HREF="pgtcl-make.html#PGTCL-MAKE-NIX"
>Building and Installing on Unix-like Systems</A
></DT
><DT
>2.2. <A
HREF="pgtcl-make-win.html"
>Building and Installing on Windows Systems (Borland Compiler)</A
></DT
><DT
>2.3. <A
HREF="pgtcl-make-macos.html"
>Building and Installing on MacOS 10</A
></DT
></DL
></DD
><DT
>3. <A
HREF="pgtcl-loading.html"
>Loading <SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> into an Application</A
></DT
><DD
><DL
><DT
>3.1. <A
HREF="pgtcl-loading.html#PGTCL-LOAD-PACKAGE"
>Using the Tcl Package Command</A
></DT
><DT
>3.2. <A
HREF="pgtcl-loading-load.html"
>Directly loading <TT
CLASS="FILENAME"
>libpgtcl</TT
></A
></DT
><DT
>3.3. <A
HREF="pgtcl-load-static.html"
>Linking <TT
CLASS="FILENAME"
>libpgtcl</TT
> Into an Application</A
></DT
></DL
></DD
><DT
>4. <A
HREF="pgtcl-ref.html"
><SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> Command Reference</A
></DT
><DD
><DL
><DT
>4.1. <A
HREF="pgtcl-ref.html#PGTCL-REF-CONNECTION"
>Database Connection Control Commands</A
></DT
><DT
>4.2. <A
HREF="pgtcl-ref-connstatus.html"
>Connection Status Commands</A
></DT
><DT
>4.3. <A
HREF="pgtcl-ref-query.html"
>Query Execution Commands</A
></DT
><DT
>4.4. <A
HREF="pgtcl-ref-async.html"
>Asynchronous Query Processing Commands</A
></DT
><DT
>4.5. <A
HREF="pgtcl-ref-notif.html"
>Notification and Notice Processing Commands</A
></DT
><DT
>4.6. <A
HREF="pgtcl-ref-largeobj.html"
>Large Object Processing Commands</A
></DT
></DL
></DD
><DT
>5. <A
HREF="pgtcl-examples.html"
>Example Programs</A
></DT
><DD
><DL
><DT
>5.1. <A
HREF="pgtcl-examples.html#PGTCL-EXAMPLE-CNQ-EXEC"
>Example - Connect and query with pg_exec</A
></DT
><DT
>5.2. <A
HREF="pgtcl-example-cnq-execute.html"
>Example - Connect and query with pg_execute</A
></DT
><DT
>5.3. <A
HREF="pgtcl-example-dblist.html"
>Example - Get List of Databases</A
></DT
><DT
>5.4. <A
HREF="pgtcl-example-results.html"
>Example - The Different Ways to Get Query Results</A
></DT
><DT
>5.5. <A
HREF="pgtcl-example-picstore-lo.html"
>Example - Large Objects - Picture Viewer, Part 1 - Store Pictures</A
></DT
><DT
>5.6. <A
HREF="pgtcl-example-picview-lo.html"
>Example - Large Objects - Picture Viewer, Part 2 - View Pictures</A
></DT
><DT
>5.7. <A
HREF="pgtcl-example-picstore-pq.html"
>Example - Prepared Queries - Picture Viewer, Part 1 - Store Pictures</A
></DT
><DT
>5.8. <A
HREF="pgtcl-example-picview-pq.html"
>Example - Prepared Queries - Picture Viewer, Part 2 - View Pictures</A
></DT
><DT
>5.9. <A
HREF="pgtcl-example-picstore-esc.html"
>Example - Bytea Escaping - Picture Viewer, Part 1 - Store Pictures</A
></DT
><DT
>5.10. <A
HREF="pgtcl-example-picview-esc.html"
>Example - Bytea Escaping - Picture Viewer, Part 2 - View Pictures</A
></DT
><DT
>5.11. <A
HREF="pgtcl-example-async.html"
>Example - Asynchronous Queries</A
></DT
><DT
>5.12. <A
HREF="pgtcl-example-copy.html"
>Example - COPY FROM and COPY TO</A
></DT
></DL
></DD
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Tables</B
></DT
><DT
>1-1. <A
HREF="pgtcl-overview.html#PGTCL-COMMANDS-TABLE"
><SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> Commands</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Examples</B
></DT
><DT
>5-1. <A
HREF="pgtcl-examples.html#PGTCL-EXAMPLE-CNQ-EXEC-CODE"
>Connect to the database and get its version with pg_exec</A
></DT
><DT
>5-2. <A
HREF="pgtcl-example-cnq-execute.html#PGTCL-EXAMPLE-CNQ-EXECUTE-CODE"
>Connect to the database and get its version with pg_execute</A
></DT
><DT
>5-3. <A
HREF="pgtcl-example-dblist.html#PGTCL-EXAMPLE-DBLIST-CODE1"
>Connect and get list of databases - pg_exec</A
></DT
><DT
>5-4. <A
HREF="pgtcl-example-dblist.html#PGTCL-EXAMPLE-DBLIST-CODE2"
>Connect and get list of databases - pg_select</A
></DT
><DT
>5-5. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE1"
>Result data: -getTuple</A
></DT
><DT
>5-6. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE2"
>Result data: -tupleArray</A
></DT
><DT
>5-7. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE3"
>Result data: -assign</A
></DT
><DT
>5-8. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE4"
>Result data: -list</A
></DT
><DT
>5-9. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE5"
>Result data: -llist</A
></DT
><DT
>5-10. <A
HREF="pgtcl-example-results.html#PGTCL-EXAMPLE-RESULTS-CODE6"
>Result data: -assignbyidx</A
></DT
><DT
>5-11. <A
HREF="pgtcl-example-picstore-lo.html#PGTCL-EXAMPLE-PICSTORE-LO-CODE"
>Large Objects - Store Pictures in Database</A
></DT
><DT
>5-12. <A
HREF="pgtcl-example-picview-lo.html#PGTCL-EXAMPLE-PICVIEW-LO-CODE"
>Large Objects - View Pictures Stored in Database</A
></DT
><DT
>5-13. <A
HREF="pgtcl-example-picstore-pq.html#PGTCL-EXAMPLE-PICSTORE-PQ-CODE"
>Prepared Queries - Store Pictures in Database</A
></DT
><DT
>5-14. <A
HREF="pgtcl-example-picview-pq.html#PGTCL-EXAMPLE-PICVIEW-PQ-CODE"
>Prepared Queries - View Pictures Stored in Database</A
></DT
><DT
>5-15. <A
HREF="pgtcl-example-picstore-esc.html#PGTCL-EXAMPLE-PICSTORE-ESC-CODE"
>Bytea Escaping - Store Pictures in Database</A
></DT
><DT
>5-16. <A
HREF="pgtcl-example-picview-esc.html#PGTCL-EXAMPLE-PICVIEW-ESC-CODE"
>Bytea Escaping - View Pictures Stored in Database</A
></DT
><DT
>5-17. <A
HREF="pgtcl-example-async.html#PGTCL-EXAMPLE-ASYNC-CODE"
>Asynchronous Queries</A
></DT
><DT
>5-18. <A
HREF="pgtcl-example-copy.html#PGTCL-EXAMPLE-COPY-CODE-TO"
>COPY TO</A
></DT
><DT
>5-19. <A
HREF="pgtcl-example-copy.html#PGTCL-EXAMPLE-COPY-CODE-FROM"
>COPY FROM</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="pgtcl-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
>