top of page
Волнистый абстрактный фон
CerebroSQL

Information_schema node in PostgreSQL

An information schema consists of a set of views containing information about the objects defined in the current database.

​

information_schema 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 = 'information_schema')
   and relkind in ('r','v','m')
 order by 2

 
Menu

  • Copy name - copy object name to clipboard

  • Create code [select] - generate query text for the object (names of all fields are displayed in the select clause)

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

bottom of page