On Fri, 14 Sep 2018 18:29:27 -0400, Tom Lane <t...@sss.pgh.pa.us> wrote:
> "Sebastian P. Luque" <splu...@gmail.com> writes: >> Tom Lane <t...@sss.pgh.pa.us> wrote: >>> Personally, I'd probably write it something like this: >>> select pa.attnum, pa.attname, col_description(pa.attrelid, >>> pa.attnum) from pg_attribute pa, pg_attribute ta where pa.attrelid = >>> 'persistent_view'::regclass and ta.attrelid = >>> 'temporary_view'::regclass and pa.attname = ta.attname order by >>> pa.attnum; >> Thank you Tom, this does seem more elegant, but I'd have to retrieve >> the actual "attrelid" from the names of the two views somehow. > That's what the regclass converter does for you. Amazing! Thank you all for these insights, -- Seb
