Re: Cannot drop column
| От | Viral Shah |
|---|---|
| Тема | Re: Cannot drop column |
| Дата | |
| Msg-id | CAEVFvu10BvsLoE5JWQrOVU4zLuyTnU1dtfhO7fuon47wTScYxg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Cannot drop column (Rich Shepard <rshepard@appl-ecosys.com>) |
| Ответы |
Re: Cannot drop column
|
| Список | pgsql-general |
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 <rshepard@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
В списке pgsql-general по дате отправления: