Retrieving Name of Tables from Database

[Anon]

Hi,

I have a database with several tables in it. How do i retrieve the names of the tables? Any suggestions to getting about it??

Thanks and Regards

[smarlowe]

That is a database dependent kind of thing, what dbms are you running?

[Anon]

with PHP and MySQL:
$get_tables = mysql_query("SHOW TABLES");
while($tables = mysql_fetch_array($get_tables)){
echo "$tables[0]<br>";
}

[smarlowe]

In postgresql, you can do it like so:

$conn=pg_connect("host=server user=username dbname=mydb");
$res=pg_exec($conn,"select * from pg_tables where tablename not like 'pg_%'");
$rows = pg_numrows($res);
for ($i=0;$i&lt;$rows;$i++){
$row = pg_fetch_array($res,$i,PGSQL_ASSOC);
print $row[tablename]."&lt;BR>";

[miyake]

There's mysql_list_tables...

mysql_connect($host,$user,$pass);
mysql_select_db($db);

$tablist = mysql_list_tables($db);
while (list($table) = mysql_fetch_array($tablist)) {
echo $table."<BR>\n";
}