Топ-100
 
CerebroSQL

PG_CATALOG node in the PostgreSQL

List of tables and views of the system catalog ( pg_catalog ) of the database

pg_catalog in the PostgreSQL.jpg

SELECT oid,
       relname as "Name"
  FROM pg_catalog.pg_class
  where relnamespace = (select oid 
                          from pg_catalog.pg_namespace n 
                         where nspname = 'pg_catalog')
    and relkind in ('r','v','m')
  order by 2

Menu
  • Copy name  - copy object name to clipboard

  • Create code [select]  - form the text of the query to the object (in the select phrase, the names of all fields are displayed)

  • Data  - display data from the table (data sheet tab)