On Wed, 5 Nov 2003, Tom Lane wrote:
> Chris Bowlby <excalibur@hub.org> writes:
> > As you can see this is a nice, clean way to break down some datasets.
> > But, if I do:
>
> > set search_path to public, test_001, test_002;
>
> > I only get access to the tables in test_001 and public, the tables in
> > test_002 are not listed, and thus I do not see them on the screen while
> > doing a "\d".
>
> Well, sure. They are masked by the identically named tables in
> test_001. How else would you expect it to work?
List of relationsSchema | Name | Type | Owner
----------+-----------------------+----------+-----------public | categories | table | 186_pgsqlpublic
| categories_rec_id_seq | sequence | 186_pgsqltest_001 | table1 | table | 186_pgsqltest_002 | table1
| table | 186_pgsql
the uniqueness, I would have thought, woudl have been schema.name, not
just name ...