29 lines
566 B
PHP
29 lines
566 B
PHP
<?php
|
|
include("../koneksi.php");
|
|
$d=pg_query("SELECT table_name FROM information_schema.tables WHERE table_schema='public'");
|
|
while($r=pg_fetch_array($d)) {
|
|
echo $r[0]."<br>";
|
|
}
|
|
?>
|
|
<br>
|
|
<br>
|
|
<?php
|
|
$d=pg_query("SELECT
|
|
column_name,
|
|
data_type
|
|
FROM
|
|
information_schema.columns
|
|
WHERE
|
|
table_name = 'riwayat_kegiatan'");
|
|
while($r=pg_fetch_array($d)) {
|
|
echo $r[0].' - '.$r[1]."<br>";
|
|
}
|
|
?>
|
|
<br>
|
|
<br>
|
|
<?php
|
|
$d=pg_query("SELECT tablename,tableowner FROM pg_tables WHERE schemaname='public'");
|
|
while($r=pg_fetch_array($d)) {
|
|
echo $r[0]." - ".$r[1]."<br>";
|
|
}
|
|
?>
|