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

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

bottom of page