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
Last activity: Jan 20, 2024, 01:56 PM