Re: Schema boggle...

"Marc G. Fournier" <scrappy@postgresql.org> 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