Re: Cannot drop column

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Wed, 18 Dec 2024 11:09:05 -0800 (PST)

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.

Rich