Postgres Pro
Downloads
Home   >   mailing lists

Re: \dt shows table but \d says the table doesn't exist ? - Mailing list pgsql-general
From hubert depesz lubaczewski
Subject Re: \dt shows table but \d says the table doesn't exist ?
Date
Msg-id ZjdENBFqXICojxwX@depesz.com
Whole thread Raw
In response to \dt shows table but \d says the table doesn't exist ?  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: I have ansible for postgres-etcd-patroni
Next
From: Kashif Zeeshan
Date:
Subject: Re: I have ansible for postgres-etcd-patroni