On Saturday, January 9, 2021, raf <raf(at)raf(dot)org> wrote:
>
> Actually, I just had a look at the pg_views system
> catalog where the source code for views is stored, and
> it doesn't seem to contain enough information to
> reconstruct a create view statement. It only contains
> these columns:
>
> schemaname
> viewname
> viewowner
> definition
>
> But definition is just the query itself.
>
> There is no list of column names (like there is with
> procedures in pg_proc).
>
> Is all of that information stored somewhere else in the
> system catalogs?
>
Views are relation-like and thus are primarily recorded on pg_class.
David J.