Топ-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
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