MIME-Version: 1.0
References: <bd67f1ba-7a58-36f8-a081-1dc6cac4e278@appl-ecosys.com>
In-Reply-To: <bd67f1ba-7a58-36f8-a081-1dc6cac4e278@appl-ecosys.com>
From: Viral Shah <viralshah009@gmail.com>
Date: Wed, 18 Dec 2024 13:51:41 -0500
Message-ID: <CAEVFvu10BvsLoE5JWQrOVU4zLuyTnU1dtfhO7fuon47wTScYxg@mail.gmail.com>
Subject: Re: Cannot drop column
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002df9c506298fe878"
Archived-At: <https://www.postgresql.org/message-id/CAEVFvu10BvsLoE5JWQrOVU4zLuyTnU1dtfhO7fuon47wTScYxg%40mail.gmail.com>
Precedence: bulk

--0000000000002df9c506298fe878
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> I'm not seeing why postgres won't drop a table's column:
>
> bustrac=3D# select * from statustypes order by stat_name;
>       stat_name
> --------------------
>   Client
>   Lead
>   No further contact
>   Opportunity
>   Proposal submitted
>   Prospect
>   Qualified
>   Referral
>   Suspect
> (9 rows)
>
> bustrac=3D# alter table statustypes drop column Suspect;
> ERROR:  column "suspect" of relation "statustypes" does not exist
> bustrac=3D#
>
> What have I done incorrectly?
>
> TIA,
>
> Rich
>
>
>

--0000000000002df9c506298fe878
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Since your column name has an Upper case character, y=
ou will have to use double quotes to drop it. Try alter table statustypes d=
rop column &quot;Suspect&quot;;</div><div><br></div><div>Thanks,</div><div>=
Viral<br></div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartma=
il=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><=
div dir=3D"ltr"><div style=3D"font-size:12.8px"><br></div></div></div></div=
></div></div></div><br></div><br><div class=3D"gmail_quote gmail_quote_cont=
ainer"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Dec 18, 2024 at 1:47=
=E2=80=AFPM Rich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rs=
hepard@appl-ecosys.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">I&#39;m not seeing why postgres won&#39;t drop a tabl=
e&#39;s column:<br>
<br>
bustrac=3D# select * from statustypes order by stat_name;<br>
=C2=A0 =C2=A0 =C2=A0 stat_name <br>
--------------------<br>
=C2=A0 Client<br>
=C2=A0 Lead<br>
=C2=A0 No further contact<br>
=C2=A0 Opportunity<br>
=C2=A0 Proposal submitted<br>
=C2=A0 Prospect<br>
=C2=A0 Qualified<br>
=C2=A0 Referral<br>
=C2=A0 Suspect<br>
(9 rows)<br>
<br>
bustrac=3D# alter table statustypes drop column Suspect;<br>
ERROR:=C2=A0 column &quot;suspect&quot; of relation &quot;statustypes&quot;=
 does not exist<br>
bustrac=3D#<br>
<br>
What have I done incorrectly?<br>
<br>
TIA,<br>
<br>
Rich<br>
<br>
<br>
</blockquote></div>

--0000000000002df9c506298fe878--