top of page
Shareware software
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

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