JavaScript Editor Javascript debugger     Website design 

pg_meta_data

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

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

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.

Parameters

connection

PostgreSQL database connection resource.

table_name

The name of the table.

Return Values

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

Examples

Example 1954. 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)
}
}


See Also
pg_convert()