pg_table_schema_pubic1.htm

select tablename as table_name, schemaname as schema_names from pg_tables where schemaname = 'public' order by tablename asc