Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot drop column - Mailing list pgsql-general

From David G. Johnston
Subject Re: Cannot drop column
Date
Msg-id CAKFQuwZSP+g5kp7apeAonRfT+ywMOGj712ONHDJAdjvo-kynVA@mail.gmail.com
Whole thread Raw
In response to Re: Cannot drop column  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
On Wednesday, December 18, 2024, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Wed, 18 Dec 2024, Rich Shepard wrote:

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 for the lesson.

But,

bustrac=# alter table statustypes drop column "Suspect"; ERROR:  column "Suspect" of relation "statustypes" does not exist
bustrac=#

Double quoting didn't resolve the issue.

Red Ron’s email…

David J. 

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Cannot drop column
Next
From: Adrian Klaver
Date:
Subject: Re: Cannot drop column