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? > stat_name is the column. "Suspect" is a row value of column stat_name. DELETE FROM statustypes WHERE stat_name = 'Suspect'; -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
