\dt shows table but \d <table> says the table doesn't exist ?

From: David Gauthier <dfgpostgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: \dt shows table but \d <table> says the table doesn't exist ?
Date: 2024-05-03 20:58:26
Message-ID: CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2024-05-03 21:06:10 Re: \dt shows table but \d <table> says the table doesn't exist ?
Previous Message Amit Sharma 2024-05-03 14:19:00 Re: Ora2pg Delta Migration: Oracle to PostgreSQL