PostgreSQL query to list all table names?

Question

Is there any query available to list all tables in my Postgres DB.

I tried out one query like:

SELECT table_name FROM information_schema.tables                       WHERE table_schema='public'  

But this query returns views also.

How can i get only table names only, not views?

Answer 1

What bout this query (based on the description from manual)?

SELECT table_name   FROM information_schema.tables  WHERE table_schema='public'    AND table_type='BASE TABLE'; 

Answer 2

If you want list of database

SELECT datname FROM pg_database WHERE datistemplate = false; 

If you want list of tables from current pg installation of all databases

SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;