public inbox for [email protected]
help / color / mirror / Atom feedFrom: Magnus Hagander <[email protected]>
To: David Gauthier <[email protected]>
Cc: [email protected]
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: Fri, 3 May 2024 23:06:10 +0200
Message-ID: <CABUevEwkSS_FhL0Zi1_m3oU5WqELHF+qQfCLDK3e__qTsYdsYw@mail.gmail.com> (raw)
In-Reply-To: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
References: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
On Fri, May 3, 2024 at 10:58 PM David Gauthier <[email protected]>
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".
>
Looks like you might need a \d "some_idIds" (include the quotes) since it
has an uppercase characters?
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
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: <CABUevEwkSS_FhL0Zi1_m3oU5WqELHF+qQfCLDK3e__qTsYdsYw@mail.gmail.com>
* 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