On Wed, Dec 18, 2024 at 11:47 AM 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? > Failed to double-quote your column name. David J.
