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, Viral On Wed, Dec 18, 2024 at 1:47 PM Rich Shepard <rshep...@appl-ecosys.com> wrote: > I'm not seeing why postgres won't drop a table's column: > > bustrac=# select * from statustypes order by stat_name; > stat_name > -------------------- > Client > Lead > No further contact > Opportunity > Proposal submitted > Prospect > Qualified > Referral > Suspect > (9 rows) > > bustrac=# alter table statustypes drop column Suspect; > ERROR: column "suspect" of relation "statustypes" does not exist > bustrac=# > > What have I done incorrectly? > > TIA, > > Rich > > >
