Re: Mapping view columns to their source columns

2019-09-25 Thread Tom Lane
Matt Andrews writes: > Incidentally, I have become interested in the pg_node_tree type. I can't > find much info on it. Would that be in the source? What would be the first > steps for writing an extension for this sort of thing? pg_node_tree is just a serialization of the tree-of-Node-structs re

Re: Mapping view columns to their source columns

2019-09-24 Thread Matt Andrews
After thinking about this one for a while, I imagined even more nightmarish scenarios than what you've just described here, and mapping the source columns no longer seems like a viable idea. Fortunately, there are a few work arounds I can rely on that particular to our database design, which means

Re: Mapping view columns to their source columns

2019-09-24 Thread Tom Lane
Matt Andrews writes: > I'm trying to map view columns to their source columns using the system > catalogs and information schema, but not having much luck. It's easy to > determine which columns a view *depends *on, but not how those columns are > mapped to the columns of the view. It seems like