Decibel! <[EMAIL PROTECTED]> writes: > While this is correct on a per-relation level, I'm thinking that it's > not what we'd really like to have happen in psql. What I'd like \d to do > is show me everything in any schema that's in my search_path, even if > there's something higher in the search_path that would over-ride it. > ISTM that's what most people would expect out of \d.
I don't agree with that reasoning in the least, particularly not if you intend to "fix" it by redefining pg_table_is_visible() ... What will happen if we change \d to work that way is that it will show you a table, and you'll try to access it, and you'll get the wrong table because the access will go to the one that really is visible. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster