CS DBA <cs_dba@consistentstate.com> writes: > 1) \d and schema's > - I setup 2 schema's (sch_a and sch_b) > - I added both schema's to my search_path > - I created 2 tables: sch_a.test_tab and sch_b.test_tab
> If I do a \d with no parameters I only see the first test_tab table > based on the order of my search_path. > I get that any queries will use the first found table if I don't specify > the schemaname but > if I'm looking for a full list (i.e. \d with no parameters) I would > think I should get a full list back
> Is this intentional?
Yes. If you want to see stuff that's invisible in your current search path, use "\d *.*". That's even documented somewhere ...
As Tom already said, am adding document pointer, you can find i