"; $result = pg_query($dbconn, "SELECT * FROM emp ORDER BY ename"); if($result) { $i = pg_num_fields($result); echo "result is ok No of fields ". $i."
"; echo ""; for ($j = 0; $j < $i; $j++) { echo""; //echo "column $j "; $fieldname = pg_field_name($result, $j); echo ""; echo "
".$fieldname." : length:" . pg_field_prtlen($result, $fieldname) . " characters\n field type: " . pg_field_type($result, $j).""; } echo"
"; } // pg_close($dbconn); ?>