On Saturday, January 9, 2021, raf <r...@raf.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.
