On Wed, Dec 18, 2024 at 1:47 PM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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!
