Re: psql \dt and identical table names across multiple schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: psql \dt and identical table names across multiple schemas
Date
Msg-id 25962.1216997063@sss.pgh.pa.us
Whole thread Raw
In response to psql \dt and identical table names across multiple schemas  ("Murat Tasan" <murat.tasan.cwru.edu@gmail.com>)
List pgsql-general
"Murat Tasan" <murat.tasan.cwru.edu@gmail.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

pgsql-general by date:

Previous
From: admin
Date:
Subject: Re: php + postgresql
Next
From: Tom Lane
Date:
Subject: Re: Full text index without accents