Susan Hurst wrote: > I'm so close but I can't quite figure out how to match view columns to > their source columns in a query. There is no simple way to find which view column matches which column in the original table. Don't forget that the column could be defined as an expression that involves several columns of the base table. You'd have to parse pg_rewrite.ev_action. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com