Топ-100
 
CerebroSQL

Node VIEW for PostgreSQL

List of views in the selected PostgreSQL database schema. The list can be filtered by entering part of the table name in the " Like name object " field

PostgreSQL View list in schema.jpg
Menu
  • Copy name  - copy view name to clipboard

  • Source  - generate the view creation code

  • Data  - display view data (limit 50)

List of views in a diagram

SELECT c.oid,
       c.relname as "Name",
       n.nspname
  FROM pg_catalog.pg_class c
  JOIN pg_catalog.pg_namespace n 
    ON n.oid = c.relnamespace
WHERE c.relkind in ('v')       
   AND n.nspname = $$SCHEMANAME

Show DDL

select view_definition 
  from information_schema.views 
where table_schema = $$VIEWSCHEMA 
   and table_name   = $$VIEWNAME