John, * John Scalia (jayknowsunix@xxxxxxxxx) wrote: > So far so good, and I get a similar output If I just set the search_path to > B, only now it properly shows the schema as b. However, if I set the > search_path to a, b; and enter \dt, I only see the tables from the first > schema "a", like the above. and not the second schema. I would have > expected: That's intentional as an unqualified object reference would pick up the object from the schema which shows up first in your search_path. > So, to me this is somewhat non-intuitive behavior, but maybe I'm all wet > here. Shouldn't \dt report all the tables it can see with the search_path > set to some value? And btw, this is was the behavior on 9.4.10, so if it's > changed in more recent versions, I haven't tested there yet. It's not changed. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
