Топ-100
top of page
Волнистый абстрактный фон
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

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) 

bottom of page