pgcatalogpgtables
pg_catalog.pg_tables, sometimes written informally as pgcatalogpgtables, is a system catalog view in PostgreSQL. It provides a convenient, read‑only listing of tables that are accessible to the current user. The view is part of the pg_catalog schema, which stores core database metadata, and is typically used for introspection and administrative tasks.
The view presents one row per table and draws on the underlying catalogs (notably pg_class and pg_namespace)
pg_tables is intended for quick discovery of base tables. It does not list views, and it may