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@xxxxxxxxxxx
