<HTML ><HEAD ><TITLE >pg_exec</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.73 "><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 7.3.2 Documentation" HREF="index.html"><LINK REL="UP" TITLE="pgtcl Command Reference Information" HREF="libpgtcl-ref.html"><LINK REL="PREVIOUS" TITLE="pg_conndefaults" HREF="pgtcl-pgconndefaults.html"><LINK REL="NEXT" TITLE="pg_result" HREF="pgtcl-pgresult.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META NAME="creation" CONTENT="2003-02-03T20:17:34"></HEAD ><BODY CLASS="REFENTRY" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PostgreSQL 7.3.2 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="pgtcl-pgconndefaults.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="pgtcl-pgresult.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="PGTCL-PGEXEC" >pg_exec</A ></H1 ><DIV CLASS="REFNAMEDIV" ><A NAME="AEN26430" ></A ><H2 >Name</H2 >pg_exec -- send a command string to the server<A NAME="IX-PGTCL-PGEXEC-1" ></A ><A NAME="IX-PGTCL-PGEXEC-2" ></A ></DIV ><DIV CLASS="REFSYNOPSISDIV" ><A NAME="AEN26438" ></A ><H2 >Synopsis</H2 ><PRE CLASS="SYNOPSIS" >pg_exec <TT CLASS="REPLACEABLE" ><I >dbHandle</I ></TT > <TT CLASS="REPLACEABLE" ><I >queryString</I ></TT ></PRE ><DIV CLASS="REFSECT2" ><A NAME="R2-PGTCL-PGEXEC-1" ></A ><H3 >Inputs</H3 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="REPLACEABLE" ><I >dbHandle</I ></TT ></DT ><DD ><P >Specifies a valid database handle.</P ></DD ><DT ><TT CLASS="REPLACEABLE" ><I >queryString</I ></TT ></DT ><DD ><P >Specifies a valid SQL query.</P ></DD ></DL ></DIV ></DIV ><DIV CLASS="REFSECT2" ><A NAME="R2-PGTCL-PGEXEC-2" ></A ><H3 >Outputs</H3 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="REPLACEABLE" ><I >resultHandle</I ></TT ></DT ><DD ><P >A Tcl error will be returned if <SPAN CLASS="APPLICATION" >pgtcl</SPAN > was unable to obtain a backend response. Otherwise, a query result object is created and a handle for it is returned. This handle can be passed to <TT CLASS="FUNCTION" >pg_result</TT > to obtain the results of the query.</P ></DD ></DL ></DIV ></DIV ></DIV ><DIV CLASS="REFSECT1" ><A NAME="R1-PGTCL-PGEXEC-1" ></A ><H2 >Description</H2 ><P ><TT CLASS="FUNCTION" >pg_exec</TT > submits a query to the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > backend and returns a result. Query result handles start with the connection handle and add a period and a result number.</P ><P >Note that lack of a Tcl error is not proof that the query succeeded! An error message returned by the backend will be processed as a query result with failure status, not by generating a Tcl error in pg_exec.</P ></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="pgtcl-pgconndefaults.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="pgtcl-pgresult.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >pg_conndefaults</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="libpgtcl-ref.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >pg_result</TD ></TR ></TABLE ></DIV ></BODY ></HTML >