PostgreSQL Select tables' names
A way to get teble names using SELECT a simple query.
Table names are stories within an implicite table pg_stat_user_tables, go get a general idea about the structure you can run the following query:
select * from pg_stat_user_tables WHERE schemaname='public'
To get table names
select relname from pg_stat_user_tables WHERE schemaname='public'
