snippetsqlCritical
How to list all views in SQL in PostgreSQL?
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
I'm running PostgreSQL v9.1.4 on Ubuntu Linux.
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:
If you don't want the system views is your result, try this:
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.