public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: David Gauthier <[email protected]>
To: [email protected]
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: Fri, 3 May 2024 14:06:38 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
References: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
On 5/3/24 13:58, David Gauthier wrote:
> 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 ?
Try:
select relname, length(relname) from pg_class where relname ilike
'%some_idIds%';
Best guess there are hidden characters.
> owner is "cron_user". \dt shows cron_user is the owner of the table.
>
>
--
Adrian Klaver
[email protected]
view thread (17+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox