Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s36Gz-009Qde-27
	for pgsql-general@arkaria.postgresql.org; Sat, 04 May 2024 03:41:16 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s36Gv-00EenW-2L
	for pgsql-general@arkaria.postgresql.org; Sat, 04 May 2024 03:41:13 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <jian.universality@gmail.com>)
	id 1s36Gu-00EenH-Ll
	for pgsql-general@lists.postgresql.org; Sat, 04 May 2024 03:41:13 +0000
Received: from mail-vk1-xa2e.google.com ([2607:f8b0:4864:20::a2e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <jian.universality@gmail.com>)
	id 1s36Gt-001RbX-2w
	for pgsql-general@lists.postgresql.org; Sat, 04 May 2024 03:41:12 +0000
Received: by mail-vk1-xa2e.google.com with SMTP id 71dfb90a1353d-4dac112e192so133198e0c.1
        for <pgsql-general@lists.postgresql.org>; Fri, 03 May 2024 20:41:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1714794069; x=1715398869; darn=lists.postgresql.org;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=nvShUV/95vkYoTcGPVoF/KipW8t/7jOnVNY5wDwaGD8=;
        b=biv/n8+eFhQRSQBxMD93zcas4cPbjLpsbuWfgcq4TTR4/T8VQlkuoP4PYUbz9T0z9B
         Kas2fV2AryE5znH96bTv8UNcH4mSNRlb+CquPG/pYOlsVT+22giaWJ/zSroS4VTv7pa8
         oixrwcof0XC+kyiz4ugt/jeG2NTp3d5+z1+X7x0Bo3/ewlv05LCnn5YyhXSYyT9cZ95t
         xOUxf1lRjAZFhh8YJZnvuATqkR6YL7UxW/aiWyx7ZtYJ3sy26EaJ9LKzexThOKman7HZ
         bKB80Km/o1N619ctdltcZ2A3JRD//VrvfOJbeYZ1sqGkJi140w1zvKY3qyNxTX8ExAET
         9dyA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1714794069; x=1715398869;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=nvShUV/95vkYoTcGPVoF/KipW8t/7jOnVNY5wDwaGD8=;
        b=JrCcwxIEbxJGCuFJLN+XLW86JfTyVVHArl3gKEf/+4PAbg4+tqmny71phK0/Dh0Dca
         YfLb3svFCxxRHezv+afWBNZ9t7WiJyxOvWcMOm6cW2zesEXQG0oyzoPC1x7/FGK2o6X+
         a7Un1o4HAyb+y0thLBG+9FXh94B/B5hJphfZcMh8r4Udp9gEs4SNcInXPrw/G3R8y8pV
         B9cAwkOtZe8lpTWvTnjQLu/ewpVTX+pDJ6KAFohw4KjOH2N0SmTe7yNa2WXhmVYgDZU5
         JJ7AbD8ARN9W5CelyW+2v3mNwsODEwd8bLkWtowKwVzk5UdufoKrs2HzXWwh2moaFs9z
         zkPA==
X-Forwarded-Encrypted: i=1; AJvYcCWiXppfr611qSEfiAxkzdYg/X9vZ2Nt3g+sxusF2WRJs/3+qusywkkYV3pCU1eUpIE1QriPzNbRYKC+T6G3lSBwNRLIunSaf1A9Hz2xjo5aeFmm
X-Gm-Message-State: AOJu0Ywx/Aix0ib+asAU9Joz0LWeJSQRL32Ua0vU4/Khkarpmy55OIQ9
	IKqirhF56Vr2uV+Hr6NaVjA6y3UkoOwYL1mVEipKoXEcc2M1lf0um2N1zLzkUyuzNIv5L9szzy1
	+4YdcKsFVMHpM8GEqcAmSEOWJv6U=
X-Google-Smtp-Source: AGHT+IFQm2hPE82XsgMexELfNYNUWkahIb/+Oirg4L/cmX5Nm8BMoqyftTFHGqs99+JXjiWzrnqUSVR51+V4gL0dD64=
X-Received: by 2002:a05:6122:99f:b0:4da:a531:ba26 with SMTP id
 g31-20020a056122099f00b004daa531ba26mr4958047vkd.6.1714794067771; Fri, 03 May
 2024 20:41:07 -0700 (PDT)
MIME-Version: 1.0
References: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
 <CABUevEwkSS_FhL0Zi1_m3oU5WqELHF+qQfCLDK3e__qTsYdsYw@mail.gmail.com>
 <7c3a1c91-566a-46f7-82b5-b47eac58c500@aklaver.com> <2746167.1714770911@sss.pgh.pa.us>
In-Reply-To: <2746167.1714770911@sss.pgh.pa.us>
From: jian he <jian.universality@gmail.com>
Date: Sat, 4 May 2024 11:40:56 +0800
Message-ID: <CACJufxF=VJ=wprULGXLuAaSt5j+4w0=66HzKDQ9GEKFXMo1-bg@mail.gmail.com>
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Magnus Hagander <magnus@hagander.net>, 
	David Gauthier <dfgpostgres@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CACJufxF%3DVJ%3DwprULGXLuAaSt5j%2B4w0%3D66HzKDQ9GEKFXMo1-bg%40mail.gmail.com>
Precedence: bulk

On Sat, May 4, 2024 at 5:15=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
> > On 5/3/24 14:06, Magnus Hagander wrote:
> >> Looks like you might need a \d "some_idIds" (include the quotes) since
> >> it has an uppercase characters?
>
> > This:
> > "Did not find any relation named "public.some_idIds"."
> > to me indicates it did look for the properly cased name.
>
> No, that message just regurgitates what you typed.  Magnus is
> correct that the pattern will be case-folded if not quoted.
> You can check with --echo-hidden (-E):
>
> postgres=3D# \d public.some_idIds
> /******** QUERY *********/
> SELECT c.oid,
>   n.nspname,
>   c.relname
> FROM pg_catalog.pg_class c
>      LEFT JOIN pg_catalog.pg_namespace n ON n.oid =3D c.relnamespace
> WHERE c.relname OPERATOR(pg_catalog.~) '^(some_idids)$' COLLATE pg_catalo=
g.default
>   AND n.nspname OPERATOR(pg_catalog.~) '^(public)$' COLLATE pg_catalog.de=
fault
> ORDER BY 2, 3;
> /************************/
>
> Did not find any relation named "public.some_idIds".
>
> So it is in fact looking for public.some_idids.
>

make it case insensitive?
like
> WHERE c.relname OPERATOR(pg_catalog.~*) '^(some_idids)$' COLLATE pg_catal=
og.default

we already transformed `\d SOME_IDIDS` to `\d some_idids`, in some way
it looks case-insensitive.