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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: David Gauthier <dfgpostgres(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: 2024-05-05 08:32:52
Message-ID: ZjdENBFqXICojxwX@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 03, 2024 at 04:58:26PM -0400, David Gauthier wrote:
> Soooooo... what am I missing ?
> owner is "cron_user". \dt shows cron_user is the owner of the table.

Magnus already helped you, but you might want to check this:
https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_upper_case_table_or_column_names
and generally read the whole "Don't Do This" wiki page.

Best regards,

depesz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kashif Zeeshan 2024-05-06 04:00:57 Re: I have ansible for postgres-etcd-patroni
Previous Message Vijaykumar Jain 2024-05-04 20:35:12 Re: I have ansible for postgres-etcd-patroni