Your Database
Overview of provenance-tagged relations
0)-1 c
FROM pg_attribute a1 JOIN pg_type ON atttypid=pg_type.oid
JOIN pg_namespace ns1 ON typnamespace=ns1.oid
JOIN pg_class ON attrelid=pg_class.oid
JOIN pg_namespace ns2 ON relnamespace=ns2.oid
WHERE typname='uuid'
AND relkind='r'
AND ns1.nspname='provsql'
AND ns2.nspname<>'provsql'
AND attname='provsql'";
$r = pg_exec($db , $req);
for ($i=0; $i
".$l["relname"]."";
echo "";
# ENTETES: affichage des noms de colonnes en balise |
$reqh = "
SELECT attname
FROM pg_attribute
WHERE attrelid = ".$l["attrelid"]."
AND attnum > 0
ORDER BY attnum";
echo " | ";
$rh = pg_exec($db, $reqh);
for ($ih=0; $ih".$lh["attname"]."";
}
echo "
";
# CONTENU: affichage des données avec en balise
$nil = pg_exec($db, "SET search_path to public,provsql");
$r2 = pg_exec($db, "select * from (select * from ".$l["relname"]." ) t");
for ($i2=0; $i2';
for ($j=0; $j<$l["c"]; $j++) {
echo '| '.$l2[$j].' | ';
}
echo "
";
}
echo "
";
}
# END PHP CODE FOR LEFT PANEL
?>