list tables for postgres?

[Anon]

i have been looking around, and have not been able to find any way to retrieve the names of tables in a database, using postgres. i know many other databases have speific functions for this purpose, so i was wondering if i had just overlooked it. thanks for any help.

[Anon]

Yes, please use the \? command in psql for help

\d I believe lists tables

[Anon]

sorry, i dont think i explained what i meant correctly... i wasnt refering to psql, but if i connected to a database in a php script, how i would go about getting a list of tables. ex. mysql has mysql_list_tables for just that purpose. i was wondering how u would go about doing that with postgresql.

[Anon]

Try this:

select tablename from pg_tables where tableowner='yourname';

[Anon]

psql --help

O;-)

...

-E Display queries that internal commands generate

Now you can play with internal commands :-)

[Anon]

This piece of code will extract and print out all the tables in your database - note: system tables are also extracted and printed out.

Good luck!

Niranjan

---

Pantheon Systems, Inc.
4560 SW 110th Ave.
Beaverton, OR 97005, USA.
503 646 6578 Phone
425 740 7083 Fax
[e-mail] Email
www.pantheon.com Internet

"The Object Technology Company"

//$dbconn is your db connection
$tableList = pg_exec($dbconn, "select * from pg_tables");
$numrows = pg_numrows($tableList);
print "Number of rows = $numrows<BR>";
for ($i=0; $i < $numrows; $i++) {
$tab_rows = pg_fetch_row($tableList, $i);
print "TableName[$i]: $tab_rows[0]<BR>\n";
}
pg_close($dbconn);
echo ("<BR>Closed");
?>

[Anon]

select tablename from pg_tables where tablename !~ '^pg_+';

will give you all the names that don't start with pg_ like all the system tables do.