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