Re: psql \dt and identical table names across multiple schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: murat(dot)tasan(at)alumni(dot)case(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql \dt and identical table names across multiple schemas
Date: 2008-07-25 14:44:23
Message-ID: 25962.1216997063@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Murat Tasan" <murat(dot)tasan(dot)cwru(dot)edu(at)gmail(dot)com> writes:
> This may have been brought up before, but if not, I thought I would bring it
> to attention, as I think this would be an easy fix.
> The problem: 2 (or more) schemas that have an identical table name.
> From within psql, the \dt (and variants of it) will only show a single
> version of that table.

That is intentional. Use \dt *.foo if you want to see all the tables
named foo.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message admin 2008-07-25 14:56:54 Re: Data base tables design questions for: user saved forms, user parameters
Previous Message Tom Lane 2008-07-25 14:42:26 Re: Full text index without accents