Sample Header Ad - 728x90

How to list all views in SQL in PostgreSQL?

77 votes
7 answers
217373 views
How do I list all views for a database using an SQL command in PostgreSQL? I would like something similar to output of the psql \dv command, but preferably just a list of view names. e.g.,
SELECT ...;
my_view_1
my_view_2
my_view_3
I'm running PostgreSQL v9.1.4 on Ubuntu Linux.
Asked by Rob Bednark (2273 rep)
Sep 6, 2012, 06:14 PM
Last activity: Jan 20, 2024, 01:56 PM