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

Mapping view columns to their source columns

2019-09-24 Thread Matt Andrews
t want to manipulate the returned data based on the types/constraints of the underlying columns of the view. It seems like mapping view columns to their source columns should be something that's been done before. Is it possible? Matt Andrews 0400 990 131