Node VIEWS for PostgreSQL
[EN]
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
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
Menu
Copy name - copy the view name to the clipboard
Source - generate the view creation code
Data - display view data (limit 50)
Show DDL
select view_definition
from information_schema.views
where table_schema = $$VIEWSCHEMA
and table_name = $$VIEWNAME
[RU]
Список представлений в выбранной схеме базы данных PostgreSQL. Список может быть отфильтрован вводом части имени таблиц в поле "Like name object"
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
Меню
Copy name - скопировать имя view в буфер обмена
Source - сформировать код создания представления
Data - отобразить данные представления (limit 50)
Show DDL
select view_definition
from information_schema.views
where table_schema = $$VIEWSCHEMA
and table_name = $$VIEWNAME