pg_field_type(3) [php man page]

PG_FIELD_TYPE(3)														  PG_FIELD_TYPE(3)

pg_field_type - Returns the type name for the corresponding field number

SYNOPSIS

       string pg_field_type (resource  $result, int  $field_number)

DESCRIPTION

       pg_field_type(3) returns a string containing the base type name of the given $field_number in the given PostgreSQL $result resource.

       Note

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

       Note

	       This function used to be called pg_fieldtype(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_number
		- Field number, starting from 0.

RETURN VALUES

	A string containing the base name of the field's type, or FALSE 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: ", pg_field_type($res, 0);
	      ?>

	      The above example will output:

	      Title field type: varchar

SEE ALSO

       pg_field_prtlen(3), pg_field_name(3), pg_field_type_oid(3).

PHP Documentation Group 													  PG_FIELD_TYPE(3)

PG_FIELD_TABLE(3)														 PG_FIELD_TABLE(3)

pg_field_table - Returns the name or oid of the tables field

SYNOPSIS

       mixed pg_field_table (resource  $result, int  $field_number, [bool  $oid_only = false])

DESCRIPTION

       pg_field_table(3) returns the name of the table that field belongs to, or the table's oid if $oid_only is TRUE.

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.

	      o $oid_only
		-  By  default	the  tables  name  that field belongs to is returned but if $oid_only is set to TRUE, then the oid will instead be
		returned.

RETURN VALUES

	On success either the fields table name or oid. Or, FALSE on failure.

EXAMPLES

       Example #1

	      Getting table information about a field

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

	      $res = pg_query($dbconn, "SELECT bar FROM foo");

	      echo pg_field_table($res, 0);
	      echo pg_field_table($res, 0, true);

	      $res = pg_query($dbconn, "SELECT version()");
	      var_dump(pg_field_table($res, 0));
	      ?>

	      The above example will output something similar to:

	      foo
	      14379580

	      bool(false)

NOTES

       Note

	       Returning the oid is much faster than returning the table name because fetching the table name requires a  query  to  the  database
	      system table.

SEE ALSO

       pg_field_name(3), pg_field_type(3).

PHP Documentation Group 													 PG_FIELD_TABLE(3)