Postgres Pro
Downloads
Home   >   mailing lists

Re: \dt shows table but \d says the table doesn't exist ? - Mailing list pgsql-general
From Adrian Klaver
Subject Re: \dt shows table but \d says the table doesn't exist ?
Date
Msg-id 32c6f80e-0531-4a30-a05c-c57bfa0d2d4c@aklaver.com
Whole thread Raw
In response to \dt shows table but \d says the table doesn't exist ?  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general
Tree view 
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: \dt shows table but \d says the table doesn't exist ?
Next
From: Adrian Klaver
Date:
Subject: Re: \dt shows table but \d
says the table doesn't exist ?