Skip to site navigation (Press enter)

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

David Gauthier Fri, 03 May 2024 13:58:54 -0700

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.
  • Previous message
  • View by thread
  • View by date
  • Next message
  • \dt shows table but \d <table> says the table does... David Gauthier
    • Re: \dt shows table but \d <table> says the t... Magnus Hagander
      • Re: \dt shows table but \d <table> says t... Adrian Klaver
        • Re: \dt shows table but \d <table> sa... Magnus Hagander
          • Re: \dt shows table but \d <table>... Tom Lane
            • Re: \dt shows table but \d <tab... Isaac Morland
        • Re: \dt shows table but \d <table> sa... David G. Johnston
        • Re: \dt shows table but \d <table> sa... Tom Lane
          • Re: \dt shows table but \d <table>... jian he
            • Re: \dt shows table but \d <tab... Tom Lane
              • Re: \dt shows table but \d <... David G. Johnston

Reply via email to

The Mail Archive
  • The Mail Archive home
  • pgsql-general - all messages
  • pgsql-general - about the list
  • Expand
  • Previous message
  • Next message
  • The Mail Archive home
  • Add your mailing list
  • FAQ
  • Support
  • Privacy
  • CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com