pg_meta_data
(PHP 4 >= 4.3.0)
pg_meta_data -- Get meta data for table.
Description
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 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 would produce the following 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)
}
}
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().
|