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
