How do I make a query return all table names?

konradatwork@hotmail.com (Konrad) writes:

I just want to send a query to the db that returns a list of all names
of all of the tables in the current database.

Is there such a query?

select * from pg_tables;

--
It would be difficult to construe Larry Wall, in article
this as a feature. <1995May29.062427.3640@netlabs.com>

off the top of my head:
"select tablename from pg_tables" will give you all tables.

"select tablename from pg_tables where tablename not like 'pg_%'" would
eliminate the internal postgres tables (and any of your's if they're name
starts with pg_)

there are fancier ways to do it, but that should work.

Robert