pg_field_table(3) [php man page]

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)

PG_FIELD_NAME(3)														  PG_FIELD_NAME(3)

pg_field_name - Returns the name of a field

SYNOPSIS

       string pg_field_name (resource  $result, int  $field_number)

DESCRIPTION

       pg_field_name(3)  returns the name of the field occupying the given $field_number in the given PostgreSQL $result resource. Field numbering
       starts from 0.

       Note

	       This function used to be called pg_fieldname(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

	The field name, or FALSE 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 * from authors where author = 'Orwell'");
		$i = pg_num_fields($res);
		for ($j = 0; $j < $i; $j++) {
		    echo "column $j
";
		    $fieldname = pg_field_name($res, $j);
		    echo "fieldname: $fieldname
";
		    echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
		    echo "storage length: " . pg_field_size($res, $j) . " bytes
";
		    echo "field type: " . pg_field_type($res, $j) . " 

";
		}
	      ?>

	      The above example will output:

	      column 0
	      fieldname: author
	      printed length: 6 characters
	      storage length: -1 bytes
	      field type: varchar

	      column 1
	      fieldname: year
	      printed length: 4 characters
	      storage length: 2 bytes
	      field type: int2

	      column 2
	      fieldname: title
	      printed length: 24 characters
	      storage length: -1 bytes
	      field type: varchar

SEE ALSO

       pg_field_num(3).

PHP Documentation Group 													  PG_FIELD_NAME(3)