function metadata($table = "")
{
$count = 0;
$id = 0;
$res = array();
if ($table) {
$this->connect();
$id = pg_exec($this->Link_ID, "SELECT * FROM {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt("Metadata query failed.");
}
} else {
$id = $this->Query_ID;
if (!$id) {
$this->halt("No query specified.");
}
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]["table"] = $table;
$res[$i]["name"] = pg_FieldName($id, $i);
$res[$i]["type"] = pg_FieldType($id, $i);
$res[$i]["len"] = pg_FieldSize($id, $i);
$res[$i]["flags"] = "";
}
if ($table) {
pg_FreeResult($id);
}
return $res;
}
function metadata($table)
{
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = pg_exec($this->Link_ID, "select * from {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt('Metadata query failed.');
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]['table'] = $table;
$res[$i]['name'] = pg_FieldName($id, $i);
$res[$i]['type'] = pg_FieldType($id, $i);
$res[$i]['len'] = pg_FieldSize($id, $i);
$res[$i]['flags'] = '';
}
pg_FreeResult($id);
return $res;
}
function metadata($table)
{
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = pg_exec($this->Link_ID, "select * from {$table} LIMIT 1");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->Errors->addError("Metadata query failed: " . $this->Error);
return 0;
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]["table"] = $table;
$res[$i]["name"] = pg_FieldName($id, $i);
$res[$i]["type"] = pg_FieldType($id, $i);
$res[$i]["len"] = pg_FieldSize($id, $i);
$res[$i]["flags"] = "";
}
pg_FreeResult($id);
return $res;
}
function metadata($table)
{
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = pg_exec($this->Link_ID, "select * from {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt("Metadata query failed.");
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]["table"] = $table;
$name = pg_FieldName($id, $i);
$res[$i]["name"] = $name;
$res[$i]["type"] = pg_FieldType($id, $i);
//zot: phplib is wrong, $name in field size should be $i
//Mike got the line above corrected.
$res[$i]["len"] = pg_FieldSize($id, $i);
$res[$i]["flags"] = "";
}
pg_FreeResult($id);
return $res;
}
