PHP/FI Get Table Description of the Table by Postgres95

Jun Kuwamura

Junk Operation & Kamikaze Engineering

$DB_NAME.$TBL_NAME"; $dbhost = "localhost"; $dbport = "5432"; $conn = pg_Connect($dbhost, $dbport, "", "", $DB_NAME); if (!$conn) { echo "An error occured Connecting to DB($DB_NAME).\n"; exit; } $sqlcmd = "SELECT a.attnum, a.attname, t.typname, a.attlen" + " FROM pg_class c, pg_attribute a, pg_type t " + " WHERE c.relname = '" + "$TBL_NAME" + "'" + " and a.attnum > 0 " + " and a.attrelid = c.oid " + " and a.atttypid = t.oid " + " ORDER BY attnum "; $result = pg_Exec($conn, $sqlcmd); if (!$result) { echo "An error occured to Exec query($sqlcmd).\n"; exit; } $nf = pg_NumFields($result); echo ""; echo ""; echo ""; $j = 0; while ($j < $nf); $fldname[] = pg_FieldName($result, $j); echo ""; $j++; endwhile; echo ""; echo "

"; >

"; echo "

"; $j = 0; while ($j < $nf); $fldval = pg_Result($result, $i, $fldname[$j]); echo ""; if ($j == 1) { $COL_NAME[$i] = $fldval; } $j++; endwhile; echo ""; echo ""; echo "

"; $i++; endwhile; echo "

Select$fldname[$j]Condition(where clause)
"; echo ""; echo "$fldval"; echo ""; echo "
"; >

Infomation of Query

"; echo "
";
   echo "Connection Result = $conn
";
   echo "SQL Command = 
 $sqlcmd
";
   echo "Result Code = $result
";
   echo "DBname =";
   echo pg_DBname($conn);
   echo "
"; pg_FreeResult($result); pg_Close($conn); >