Re: Cannot drop column

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Wed, 18 Dec 2024, Viral Shah 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";

Viral,

Huh! I've not before encountered this in the 30+ years I've used postgres.

Thanks for the lesson.

Regards,

Rich