The view pg_views provides access to useful information about each view in the database.
pg_views ColumnsColumn Type
Description
schemaname name (references .nspname)
Name of schema containing view
viewname name (references .relname)
Name of view
viewowner name (references .rolname)
Name of view's owner
definition text
View definition (a reconstructed query)