pg_meta_data

Get meta data for table. (PHP 4 >= 4.3.0)
array pg_meta_data ( resource connection, string table_name )

pg_meta_data() returns table definition for table_name as an array. If there is error, it returns FALSE

Example 761. Getting table metadata

copy to clipboard
<?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 would produce the following output:

copy to clipboard
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)
 }
}
Warning:

This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.

See also pg_convert().

This HTML Help has been published using the chm2web software.