Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot drop column - Mailing list pgsql-general

From Viral Shah
Subject Re: Cannot drop column
Date
Msg-id CAEVFvu10BvsLoE5JWQrOVU4zLuyTnU1dtfhO7fuon47wTScYxg@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
Tree view
Since your column name has an Upper case character, you will have to use double quotes to drop it. Try alter table statustypes drop column "Suspect";

Thanks,
Viral



On Wed, Dec 18, 2024 at 1:47 PM 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?

TIA,

Rich


pgsql-general by date:

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