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 1s2zzQ-008Fxi-U1
	for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 20:58:44 +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 1s2zzO-00Buvw-1m
	for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 20:58:42 +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 <dfgpostgres@gmail.com>)
	id 1s2zzN-00Buvm-N9
	for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 20:58:42 +0000
Received: from mail-pg1-x52e.google.com ([2607:f8b0:4864:20::52e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <dfgpostgres@gmail.com>)
	id 1s2zzM-001Okm-7K
	for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 20:58:42 +0000
Received: by mail-pg1-x52e.google.com with SMTP id 41be03b00d2f7-5e152c757a5so49604a12.2
        for <pgsql-general@lists.postgresql.org>; Fri, 03 May 2024 13:58:39 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1714769917; x=1715374717; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=E8Orj9IMv+O5yAUpamf+jyxDbl4uaJrID/ogIfEDXE0=;
        b=L+6MC7BkWHLIQNCqev0sXidZgh4EVWoHln+eaJpiCWvozpu7JWG8fAQIsoh1cKqvwz
         JXkcm7fk+FIQ3Vv61xQVyneTQWgTVg8zSyhklttiX/e+O2rkIS3Mkyfly6R3Douw/YVJ
         5CRD8LwtRrS/DXs7hRWYrRe2q6jbk3BRTV2L2S73bRH6U9boW48ru45ZXS3t1eQv93N5
         CfSgUmNo3fnvARwHLpW84ctql3lnscLj+pn6SShyN8neVcROSaaUgBbS5KT1q93DLl98
         grZn84J9pS3O53SCjDUszGiLKEY5Gpr4Fl0mPrM3cXXfX8Pr2wOwYFYHRIhvmNZHGUno
         f59A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1714769917; x=1715374717;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=E8Orj9IMv+O5yAUpamf+jyxDbl4uaJrID/ogIfEDXE0=;
        b=T92CxVtMIk2aa3kdy5e8Ju+3yOZoPL9zAHF0FU/4OcefzP1ybCt5Ok156ntLKZpO1d
         1oBoBx4WVXbSoPoMiO4+on+wmErCCKjCB3sJoNCdo4xgcTLBH7UQCdJP8xvTybcHPl9C
         71lJnq2buWs/jG/wtIxUm3kSBHL1q8kYoe3eZSBkt6oSNb5qYG96fQrKVbtVoooLKAW3
         oOTRMg+2burOVvU6qV3y7AynpdmcgYfysqeq7da/818F3lsQ28/U8cfOJjFf0fIjEP3L
         vjVQ4oXRtK0TOdpgxdWNQxgZG6sT6DkrtyQCnkht5icfVS/HZBsHUpNKkFzteMlmtePt
         1D1w==
X-Gm-Message-State: AOJu0Yxa6G2y+cpyOmcqmZsnopwirFAcAVXARscJBvO0d6oCmzZSvhDS
	FZA4da0lcgvtc1T+o6smlUe5Kua16Q2+AsfNDibJwGsmjPji23UjlbceysbpANsBjx9OQYOKzKT
	Sx4jK3AUr7Wlh+SrdiCSFs/5e7jMjVkj3
X-Google-Smtp-Source: AGHT+IEREiq8qKoNjq+upj7somMY8eoMx5hhsKBh2P28zShPDjeIOcfrL2nDGk3fJ5OCwSqtCS/YYWK5iFLJ6eoiEy4=
X-Received: by 2002:a17:90b:80a:b0:2b4:8eb6:895f with SMTP id
 bk10-20020a17090b080a00b002b48eb6895fmr1106021pjb.16.1714769917339; Fri, 03
 May 2024 13:58:37 -0700 (PDT)
MIME-Version: 1.0
From: David Gauthier <dfgpostgres@gmail.com>
Date: Fri, 3 May 2024 16:58:26 -0400
Message-ID: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
Subject: \dt shows table but \d <table> says the table doesn't exist ?
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cb71aa061792fb3a"
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/CAEs%3D6DnMQCAF_c%2B%3DVup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg%40mail.gmail.com>
Precedence: bulk

--000000000000cb71aa061792fb3a
Content-Type: text/plain; charset="UTF-8"

psql (15.3, server 14.5) on linux

Someone else's DB which I've been asked to look at.

\dt gives many tables, here are just 3...

 public | some_idIds                                       | table |
cron_user
 public | WarningIds                                       | table |
cron_user
 public | cpf_inv_driverIds                                | table |
cron_user

but \d public.some_idIds gives..

Did not find any relation named "public.some_idIds".

Soooooo... what am I missing ?
owner is "cron_user".  \dt shows cron_user is the owner of the table.

--000000000000cb71aa061792fb3a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">psql (15.3, server 14.5) on linux<br><div><br></div><div>S=
omeone else&#39;s DB which I&#39;ve been asked to look at.</div><div><br></=
div><div>\dt gives many tables, here are just 3...</div><div><br></div><div=
>=C2=A0public | some_idIds =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 | table | cron_user<br></div><div>=C2=A0public | WarningIds =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | table | cron_user=
<br></div><div>=C2=A0public | cpf_inv_driverIds =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0| table | cron_user<br></div><div><br></div><div>but \d public.so=
me_idIds gives..</div><div><br></div><div>Did not find any relation named &=
quot;public.some_idIds&quot;.<br></div><div><br></div><div>Soooooo... what =
am I missing ?<br>owner is &quot;cron_user&quot;.=C2=A0 \dt shows cron_user=
 is the owner of the table.</div><div><br></div><div><br></div></div>

--000000000000cb71aa061792fb3a--