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

From: 徐志宇徐 <xuzhiyuster(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: About psql \dt unable display same name table which have different schema
Date: 2022-05-24 15:59:51
Message-ID: CAOCebiKq7fmsGr36ON5_Fru2dQJBB6NY3m_NnLs94CbUek=AZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All

I experience a problem. The psql \dt command unable display
same name table which have different schema.

The table new. test10 unable display.
Owing to the public.test10 exist. The pg_type_is_visible display "F"

I don't know why this problem exist. Why unable display both table "
public.test10 、 new. test10 "

For example:

new01=# create table public.test10 (id int);
CREATE TABLE
new01=# create table new.test10(id int);
CREATE TABLE
new01=# create table new.test11(id int);
CREATE TABLE
new01=# show search_path ;
search_path
----------------------------
"$user", public, new2, new
(1 row)

new01=# \dt
List of relations
Schema | Name | Type | Owner
--------+--------+-------+----------
new | test01 | table | test01
new | test02 | table | postgres
new | test11 | table | postgres
public | tbl_a | table | postgres
public | tbl_c | table | postgres
public | test10 | table | postgres
(6 rows)
new01=# SELECT pg_type_is_visible('public.test10'::regtype);
pg_type_is_visible
--------------------
t
(1 row)

new01=# SELECT pg_type_is_visible('new.test10'::regtype);
pg_type_is_visible
--------------------
f
(1 row)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-05-24 16:11:49 Re: existing row not found by SELECT ... WHERE CTID = ?
Previous Message Laurenz Albe 2022-05-24 15:50:14 Re: existing row not found by SELECT ... WHERE CTID = ?