pg_field_type_oid

Returns the type ID (OID) for the corresponding field number (PHP 5 >= 5.1.0)
int pg_field_type_oid ( resource result, int field_number )

Example 1932. 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:

copy to clipboard

Title field type OID: 1043

Code Examples / Notes » pg_field_type_oid

This function can be used to improve the performance of your application. pg_field_type() makes an internal query to the pg_type table and it can be really slow. So if your application previously know the oids of your database, you can save the execution time of this query in every request.

pg_field_type_oid

Returns the type ID (OID) for the corresponding field number (PHP 5 >= 5.1.0) int pg_field_type_oid ( resource result, int field_number )

Example 1932. Getting information about fields

Code Examples / Notes » pg_field_type_oid

Change Language

Returns the type ID (OID) for the corresponding field number (PHP 5 >= 5.1.0)
int pg_field_type_oid ( resource result, int field_number )