PostgreSQL – List all views

You can query the system catalog table ‘views’ to list all the views of a postgres database as shown below:

SELECT table_schema, table_name from information_schema.views;

See also  PostgreSQL - Get first row within each group