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)
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 = ? |