"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> How else would you expect it to work?
> List of relations
> Schema | Name | Type | Owner
> ----------+-----------------------+----------+-----------
> public | categories | table | 186_pgsql
> public | categories_rec_id_seq | sequence | 186_pgsql
> test_001 | table1 | table | 186_pgsql
> test_002 | table1 | table | 186_pgsql
You can get something like that if you say "\d *.*". If you say "\d *"
or equivalently just "\d", then what you see is only the tables that you
could reference with unqualified names. Which does not include the
tables in test_002, because they're hidden by the ones in test_001.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
