Re: About psql \dt unable display same name table which have different schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 徐志宇徐 <xuzhiyuster(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: About psql \dt unable display same name table which have different schema
Date: 2022-05-24 16:16:09
Message-ID: 1652895.1653408969@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?B?5b6Q5b+X5a6H5b6Q?= <xuzhiyuster(at)gmail(dot)com> writes:
> I don't know why this problem exist. Why unable display both table "
> public.test10 、 new. test10 "

That's behaving as designed: \dt will show you tables that are
accessible with an unqualified name, but new.test10 is hidden
behind public.test10, so it's not accessible except by
qualification.

You can do "\dt *.*" or "\dt new.*", etc, to see such tables.

See here for more info:

https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-PATTERNS

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 徐志宇徐 2022-05-24 16:39:00 Re: About psql \dt unable display same name table which have different schema
Previous Message Tom Lane 2022-05-24 16:11:49 Re: existing row not found by SELECT ... WHERE CTID = ?