Information_schema node in PostgreSQL

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

​

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)