HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlCritical

How to list all views in SQL in PostgreSQL?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlallsqlviewshowlist

Problem

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.

Solution

From the documentation:

select table_name from INFORMATION_SCHEMA.views;


If you don't want the system views is your result, try this:

select table_name from INFORMATION_SCHEMA.views WHERE table_schema = ANY (current_schemas(false))

Code Snippets

select table_name from INFORMATION_SCHEMA.views;
select table_name from INFORMATION_SCHEMA.views WHERE table_schema = ANY (current_schemas(false))

Context

StackExchange Database Administrators Q#23836, answer score: 88

Revisions (0)

No revisions yet.