Find list of views present
postgres=# select * from pg_views where schemaname not in ('pg_catalog','information_schema','sys'); count -------
postgresql configurationintermediate
by PostgreSQL
13 views
📋Steps in this guide1/1
1
Find list of views present
Code/Command (click line numbers to comment):
1234567891011
postgres=#
select * from pg_views where schemaname not in ('pg_catalog','information_schema','sys');
count
-------
postgres#
\dv
List of relations
Schema | Name | Type | Owner
--------+--------------------+------+--------------
public | pg_stat_statements | view | enterprisedb
(1 row)Comments (0)
Please to add comments
No comments yet. Be the first to comment!