From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | David Gauthier <dfgpostgres(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: \dt shows table but \d <table> says the table doesn't exist ? |
Date: | 2024-05-03 21:06:38 |
Message-ID: | 32c6f80e-0531-4a30-a05c-c57bfa0d2d4c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-05-03 21:08:26 | Re: \dt shows table but \d <table> says the table doesn't exist ? |
Previous Message | Magnus Hagander | 2024-05-03 21:06:10 | Re: \dt shows table but \d <table> says the table doesn't exist ? |