On Wed, Dec 18, 2024 at 11:47 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:
> I'm not seeing why postgres won't drop a table's column:
>
> bustrac=# select * from statustypes order by stat_name;
> stat_name
> --------------------
> Client
> Lead
> No further contact
> Opportunity
> Proposal submitted
> Prospect
> Qualified
> Referral
> Suspect
> (9 rows)
>
> bustrac=# alter table statustypes drop column Suspect;
> ERROR: column "suspect" of relation "statustypes" does not exist
> bustrac=#
>
> What have I done incorrectly?
>
Failed to double-quote your column name.
David J.