On 12/18/24 11:04 AM, Rich Shepard wrote:
On Wed, 18 Dec 2024, Viral Shah wrote:
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";
Viral,
Huh! I've not before encountered this in the 30+ y
On Wednesday, December 18, 2024, Rich Shepard
wrote:
> On Wed, 18 Dec 2024, Rich Shepard wrote:
>
> 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 for the lesson.
>>
>
>
On Wed, 18 Dec 2024, Rich Shepard wrote:
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 for the lesson.
But,
bustrac=# alter table statustypes drop column "Suspect";
ERROR: colum
On Wed, 18 Dec 2024, David G. Johnston wrote:
Failed to double-quote your column name.
David,
Thanks. That's a new one on me.
Regards,
Rich
On Wed, 18 Dec 2024, Viral Shah wrote:
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";
Viral,
Huh! I've not before encountered this in the 30+ years I've used postgres.
Thanks for the lesson
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
wrote:
> I'm not seeing why postgres won't drop a table's column:
>
> bustrac=# sele
On Wed, Dec 18, 2024 at 1:47 PM Rich Shepard
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
>
On Wed, Dec 18, 2024 at 11:47 AM Rich Shepard
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
>
