Топ-100
 
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.jpg

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]  - 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)