This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
query
Name
query -- execute a SQL command
Synopsis
query(command)
Parameters
command-
SQL command (string).
Return Type
pgqueryobject or
None-
Result values.
Exceptions
TypeError-
Bad argument type, or too many arguments.
ValueError-
Empty SQL query.
pg.error-
Error during query processing, or invalid
connection.
Description
query() method sends a
SQL query to the database. If
the query is an insert statement, the return value is the
OID 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 SELECT statement),
it returns None. Otherwise, it returns a
pgqueryobject that can be accessed
via the getresult() or dictresult() methods or simply printed.