<function>PQdb</function>

Returns the database name of the connection.

<synopsis>

constchar *PQdb(const PGconn *conn)

char *PQdb(const PGconn *conn)

</synopsis>

PQdb and the next several functions return the values established

at connection. These values are fixed for the life of the PGconn

<function>PQuser</function>

Returns the user name of the connection.

<synopsis>

constchar *PQuser(const PGconn *conn)

char *PQuser(const PGconn *conn)

</synopsis>

</para>

</listitem>

<function>PQpass</function>

Returns the password of the connection.

<synopsis>

constchar *PQpass(const PGconn *conn)

char *PQpass(const PGconn *conn)

</synopsis>

</para>

</listitem>

<function>PQhost</function>

Returns the server host name of the connection.

<synopsis>

constchar *PQhost(const PGconn *conn)

char *PQhost(const PGconn *conn)

</synopsis>

</para>

</listitem>

<function>PQport</function>

Returns the port of the connection.

<synopsis>

constchar *PQport(const PGconn *conn)

char *PQport(const PGconn *conn)

</synopsis>

</para>

</listitem>

<function>PQtty</function>

Returns the debug tty of the connection.

<synopsis>

constchar *PQtty(const PGconn *conn)

char *PQtty(const PGconn *conn)

</synopsis>

</para>

</listitem>

<function>PQoptions</function>

Returns the backend options used in the connection.

<synopsis>

constchar *PQoptions(const PGconn *conn)

char *PQoptions(const PGconn *conn)

</synopsis>

</para>

</listitem>

Returns the error message most recently generated by

an operation on the connection.

<synopsis>

constchar *PQerrorMessage(const PGconn* conn);

char *PQerrorMessage(const PGconn* conn);

</synopsis>

</para>

Converts the enumerated type returned by PQresultStatus into

a string constant describing the status code.

<synopsis>

constchar *PQresStatus(ExecStatusType status);

char *PQresStatus(ExecStatusType status);

</synopsis>

</para>

</listitem>

returns the error message associated with the query, or an empty string

if there was no error.

<synopsis>

constchar *PQresultErrorMessage(const PGresult *res);

char *PQresultErrorMessage(const PGresult *res);

</synopsis>

Immediately following a <function>PQexec</function> or <function>PQgetResult</function>

call, <function>PQerrorMessage</function> (on the connection) will return the same

Returns the field (attribute) name associated with the given field index.

Field indices start at 0.

<synopsis>

constchar *PQfname(const PGresult *res,

char *PQfname(const PGresult *res,

int field_index);

</synopsis>

</para>

of a PGresult.

Tuple and field indices start at 0.

<synopsis>

constchar* PQgetvalue(const PGresult *res,

int tup_num,

int field_num);

char* PQgetvalue(const PGresult *res,

int tup_num,

int field_num);

</synopsis>

For most queries, the value returned by <function>PQgetvalue</function>

is a null-terminated <acronym>ASCII</acronym> string representation

Returns the command status string from the SQL command that

generated the PGresult.

<synopsis>

constchar * PQcmdStatus(const PGresult *res);

char * PQcmdStatus(const PGresult *res);

</synopsis>

</para>

</listitem>

<function>PQcmdTuples</function>

Returns the number of rows affected by the SQL command.

<synopsis>

constchar * PQcmdTuples(const PGresult *res);

char * PQcmdTuples(const PGresult *res);

</synopsis>

If the <acronym>SQL</acronym> command that generated the

PGresult was INSERT, UPDATE or DELETE, this returns a

inserted, if the <acronym>SQL</acronym> command was an INSERT.

Otherwise, returns an empty string.

<synopsis>

constchar * PQoidStatus(const PGresult *res);

char * PQoidStatus(const PGresult *res);

</synopsis>

The function is deprecated in favor of <function>PQoidValue</function>

and is not thread-safe.

const PQprintOpt *po);

struct {

int header; /* print output field headings and row count */

int align; /* fill align the fields */

int standard; /* old brain dead format */

int html3; /* output html tables */

int expanded; /* expand tables */

int pager; /* use pager for output if needed */

pqbool header; /* print output field headings and row count */

pqbool align; /* fill align the fields */

pqbool standard; /* old brain dead format */

pqbool html3; /* output html tables */

pqbool expanded; /* expand tables */

pqbool pager; /* use pager for output if needed */

char *fieldSep; /* field separator */

char *tableOpt; /* insert to HTML &lt;table ...&gt; */

char *caption; /* HTML &lt;caption&gt; */

char **fieldName; /* null terminated array of replacement field names */

} PQprintOpt;

</synopsis>

This function was formerly used by <application>psql</application>

to print query results, but this is no longer the case and this

function is no longer supported.

function is no longeractivelysupported.

</para>

</listitem>

</listitem>

<listitem>

<para>

<function>PQclear</function>