<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>Large Object Processing Commands</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Pgtcl Reference Manual"
HREF="index.html"><LINK
REL="UP"
TITLE="pgtcl Command Reference"
HREF="pgtcl-ref.html"><LINK
REL="PREVIOUS"
TITLE="pg_notice_handler"
HREF="pg-notice-handler.html"><LINK
REL="NEXT"
TITLE="pg_lo_creat"
HREF="pg-lo-creat.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
NAME="creation"
CONTENT="2004-11-09T00:53:06"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Pgtcl Reference Manual: The PostgreSQL Tcl Interface</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="pg-notice-handler.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 4. <SPAN
CLASS="APPLICATION"
>pgtcl</SPAN
> Command Reference</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="pg-lo-creat.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="PGTCL-REF-LARGEOBJ"
>4.6. Large Object Processing Commands</A
></H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
HREF="pg-lo-creat.html"
>pg_lo_creat</A
> -- create a large object</DT
><DT
><A
HREF="pg-lo-open.html"
>pg_lo_open</A
> -- open a large object</DT
><DT
><A
HREF="pg-lo-close.html"
>pg_lo_close</A
> -- close a large object</DT
><DT
><A
HREF="pg-lo-read.html"
>pg_lo_read</A
> -- read from a large object</DT
><DT
><A
HREF="pg-lo-write.html"
>pg_lo_write</A
> -- write to a large object</DT
><DT
><A
HREF="pg-lo-lseek.html"
>pg_lo_lseek</A
> -- seek to a position of a large object</DT
><DT
><A
HREF="pg-lo-tell.html"
>pg_lo_tell</A
> -- return the current seek position of a large object</DT
><DT
><A
HREF="pg-lo-unlink.html"
>pg_lo_unlink</A
> -- delete a large object</DT
><DT
><A
HREF="pg-lo-import.html"
>pg_lo_import</A
> -- import a large object from a file</DT
><DT
><A
HREF="pg-lo-export.html"
>pg_lo_export</A
> -- export a large object to a file</DT
></DL
></DIV
><BLOCKQUOTE
CLASS="ABSTRACT"
><DIV
CLASS="ABSTRACT"
><P
></P
><A
NAME="AEN2128"
></A
><P
>The commands in this section are used to create and work with
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> Large Objects. For more
information about Large Objects, refer to the
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> reference manual, Client
Interfaces, Large Objects chapter.
</P
><P
></P
></DIV
></BLOCKQUOTE
><DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Note: </B
>The Large Object commands must be used within a transaction block,
beginning with <TT
CLASS="COMMAND"
>BEGIN</TT
> and ending with
<TT
CLASS="COMMAND"
>COMMIT</TT
> or <TT
CLASS="COMMAND"
>ROLLBACK</TT
>.
This is because the large object file descriptors (returned
by <A
HREF="pg-lo-open.html"
>pg_lo_open</A
>) are only valid for the current
transaction.
</P
><P
>Examples of Large Object commands can be found in
<A
HREF="pgtcl-example-picstore-lo.html"
>Section 5.5</A
> and
<A
HREF="pgtcl-example-picview-lo.html"
>Section 5.6</A
>.
</P
></BLOCKQUOTE
></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="pg-notice-handler.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="pg-lo-creat.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>pg_notice_handler</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="pgtcl-ref.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>pg_lo_creat</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
