pg_field_num(3) [php man page]

PG_FIELD_NUM(3) 														   PG_FIELD_NUM(3)

pg_field_num - Returns the field number of the named field

SYNOPSIS

       int pg_field_num (resource  $result, string  $field_name)

DESCRIPTION

       pg_field_num(3) will return the number of the field number that corresponds to the $field_name in the given PostgreSQL $result resource.

       Note

	       This function used to be called pg_fieldnum(3).

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

	      o $field_name
		- The name of the field.

RETURN VALUES

	The field number (numbered from 0), or -1 on error.

EXAMPLES

       Example #1

	      Getting information about fields

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		$res = pg_query($dbconn, "select author, year, title from authors where author = 'Orwell'");

		echo "Column 'title' is field number: ", pg_field_num($res, 'title');
	      ?>

	      The above example will output:

	      Column 'title' is field number: 2

SEE ALSO

       pg_field_name(3).

PHP Documentation Group 													   PG_FIELD_NUM(3)

PG_FIELD_TYPE_OID(3)													      PG_FIELD_TYPE_OID(3)

pg_field_type_oid - Returns the type ID (OID) for the corresponding field number

SYNOPSIS

       int pg_field_type_oid (resource	$result, int  $field_number)

DESCRIPTION

       pg_field_type_oid(3)  returns  an  integer  containing  the OID of the base type of the given $field_number in the given PostgreSQL $result
       resource.

	You can get more information about the field type by querying PostgreSQL's pg_type system table using the OID obtained with this function.
       The PostgreSQL format_type(3) function will convert a type OID into an SQL standard type name.

       Note

	       If  the	field uses a PostgreSQL domain (rather than a basic type), it is the OID of the domain's underlying type that is returned,
	      rather than the OID of the domain itself.

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

	      o $field_number
		- Field number, starting from 0.

RETURN VALUES

	The OID of the field's base type.  FALSE is returned on error.

EXAMPLES

       Example #1

	      Getting information about fields

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		// Assume 'title' is a varchar type
		$res = pg_query($dbconn, "select title from authors where author = 'Orwell'");

		echo "Title field type OID: ", pg_field_type_oid($res, 0);
	      ?>

	      The above example will output:

	      Title field type OID: 1043

SEE ALSO

       pg_field_type(3), pg_field_prtlen(3), pg_field_name(3).

PHP Documentation Group 												      PG_FIELD_TYPE_OID(3)