| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Cc: | chris(at)hub(dot)org, pgsql-hackers(at)postgresql(dot)org, chris(at)pgsql(dot)com, geoff(at)pgsql(dot)com |
| Subject: | Re: Schema boggle... |
| Date: | 2003-11-05 22:08:03 |
| Message-ID: | 13773.1068070083@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Marc G. Fournier" <scrappy(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-11-05 22:16:48 | Re: [HACKERS] Changes to Contributor List |
| Previous Message | Matthew T. O'Connor | 2003-11-05 22:06:40 | Re: Performance features the 4th |