pg_field_name(3) [php man page]

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)

PG_META_DATA(3) 														   PG_META_DATA(3)

pg_meta_data - Get meta data for table

SYNOPSIS

       array pg_meta_data (resource  $connection, string  $table_name, [bool  $extended])

DESCRIPTION

       pg_meta_data(3) returns table definition for table_name as an array.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

	      o $table_name
		- The name of the table.

	      o $extended
		- Flag for returning extended meta data. Default to FALSE.

RETURN VALUES

	An array of the table definition, or FALSE on error.

EXAMPLES

       Example #1

	      Getting table metadata

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

		$meta = pg_meta_data($dbconn, 'authors');
		if (is_array($meta)) {
		    echo '<pre>';
		    var_dump($meta);
		    echo '</pre>';
		}
	      ?>

	      The above example will output:

	      array(3) {
	      ["author"]=>
	      array(5) {
		["num"]=>
		int(1)
		["type"]=>
		string(7) "varchar"
		["len"]=>
		int(-1)
		["not null"]=>
		bool(false)
		["has default"]=>
		bool(false)
	      }
	      ["year"]=>
	      array(5) {
		["num"]=>
		int(2)
		["type"]=>
		string(4) "int2"
		["len"]=>
		int(2)
		["not null"]=>
		bool(false)
		["has default"]=>
		bool(false)
	      }
	      ["title"]=>
	      array(5) {
		["num"]=>
		int(3)
		["type"]=>
		string(7) "varchar"
		["len"]=>
		int(-1)
		["not null"]=>
		bool(false)
		["has default"]=>
		bool(false)
	      }
	      }

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.6.0	|						    |
       |	|						    |
       |	|  No  longer  experimental.  Added  "is  enum"  as |
       |	| default attribute. $extended flag is added.	    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       pg_convert(3).

PHP Documentation Group 													   PG_META_DATA(3)