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.