Re: Cannot drop column - Mailing list pgsql-general

From David G. Johnston
Subject Re: Cannot drop column
Date
Msg-id CAKFQuwaBO3fA0cKLHGEEVZQHV_-NVMG8S5NYQKxcPy+qFSj5ZQ@mail.gmail.com
Whole thread Raw
In response to Cannot drop column  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Cannot drop column
List pgsql-general
On Wed, Dec 18, 2024 at 11:47 AM Rich Shepard <rshepard@appl-ecosys.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.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Cannot drop column
Next
From: Ron Johnson
Date:
Subject: Re: Cannot drop column