<HTML ><HEAD ><TITLE >query</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="Connection Object: pgobject" HREF="pygresql-pg-pgobject.html"><LINK REL="PREVIOUS" TITLE="Connection Object: pgobject" HREF="pygresql-pg-pgobject.html"><LINK REL="NEXT" TITLE="reset" HREF="pygresql-reset.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="pygresql-pg-pgobject.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="pygresql-reset.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="PYGRESQL-QUERY" >query</A ></H1 ><DIV CLASS="REFNAMEDIV" ><A NAME="AEN29675" ></A ><H2 >Name</H2 >query -- execute a SQL command</DIV ><DIV CLASS="REFSYNOPSISDIV" ><A NAME="AEN29678" ></A ><H2 >Synopsis</H2 ><PRE CLASS="SYNOPSIS" >query(<TT CLASS="PARAMETER" ><I >command</I ></TT >)</PRE ><DIV CLASS="REFSECT2" ><A NAME="R2-PYGRESQL-QUERY-1" ></A ><H3 >Parameters</H3 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="PARAMETER" ><I >command</I ></TT ></DT ><DD ><P >SQL command (string).</P ></DD ></DL ></DIV ></DIV ><DIV CLASS="REFSECT2" ><A NAME="R2-PYGRESQL-QUERY-2" ></A ><H3 >Return Type</H3 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="CLASSNAME" >pgqueryobject</TT > or <TT CLASS="SYMBOL" >None</TT ></DT ><DD ><P > Result values. </P ></DD ></DL ></DIV ></DIV ><DIV CLASS="REFSECT2" ><A NAME="R2-PYGRESQL-QUERY-3" ></A ><H3 >Exceptions</H3 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="CLASSNAME" >TypeError</TT ></DT ><DD ><P > Bad argument type, or too many arguments. </P ></DD ><DT ><TT CLASS="CLASSNAME" >ValueError</TT ></DT ><DD ><P > Empty SQL query. </P ></DD ><DT ><TT CLASS="CLASSNAME" >pg.error</TT ></DT ><DD ><P > Error during query processing, or invalid connection. </P ></DD ></DL ></DIV ></DIV ></DIV ><DIV CLASS="REFSECT1" ><A NAME="R1-PYGRESQL-QUERY-1" ></A ><H2 >Description</H2 ><P > <TT CLASS="FUNCTION" >query()</TT > method sends a <SPAN CLASS="ACRONYM" >SQL</SPAN > query to the database. If the query is an insert statement, the return value is the <SPAN CLASS="ACRONYM" >OID</SPAN > of the newly inserted row. If it is otherwise a query that does not return a result (i.e., is not a some kind of <TT CLASS="LITERAL" >SELECT</TT > statement), it returns <TT CLASS="SYMBOL" >None</TT >. Otherwise, it returns a <TT CLASS="CLASSNAME" >pgqueryobject</TT > that can be accessed via the <TT CLASS="FUNCTION" >getresult()</TT > or <TT CLASS="FUNCTION" >dictresult()</TT > methods or simply printed. </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="pygresql-pg-pgobject.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="pygresql-reset.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Connection Object: <TT CLASS="CLASSNAME" >pgobject</TT ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="pygresql-pg-pgobject.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >reset</TD ></TR ></TABLE ></DIV ></BODY ></HTML >