list tables from PHP

Mariusz Kaczmarczyk

Hello, i can't find any matching answer for this question.

How to construct SQL query to list all tables in current database? Let's say
i use the default view. Or maybe there is better way in PHP to do it?

PostgreSQL version 7.3.

TIA

--
Mariusz Kaczmarczyk 'koshmar' | mailto:koshmar/DELETE/@poczta.fm
jabber: koshmar/DELETE/@amessage.info | GG: 1797253
http://www.ck-la.tk/ | http://www.mieszkanie-prawem.w.pl/

Jul 19 '05 #1

Mariusz Kaczmarczyk

Mariusz Kaczmarczyk wrote:

How to construct SQL query to list all tables in current database? Let's
say i use the default view. Or maybe there is better way in PHP to do it?

I have already found it, 15 minutes after posting (and after 1 day of
looking for it previously).

Use
SELECT relname FROM pg_stat_user_tables ORDER BY relname

--
Mariusz Kaczmarczyk 'koshmar' | mailto:koshmar/DELETE/@poczta.fm
jabber: koshmar/DELETE/@amessage.info | GG: 1797253
http://www.ck-la.tk/ | http://www.mieszkanie-prawem.w.pl/

Jul 19 '05 #2