List all tables in postgresql information_schema
You should be able to just run select * from information_schema.tables to get a listing of every table being managed by Postgres for a particular database.
You can also add a where table_schema = 'information_schema' to see just the tables in the information schema.
For listing your tables use:
SELECT table_name FROM information_schema.tables WHERE table_schema='public'It will only list tables that you create.