Re: Cannot drop column - Mailing list pgsql-general

From Rich Shepard
Subject Re: Cannot drop column
Date
Msg-id b6195a7-d380-ff9-78a0-8a9566555a48@appl-ecosys.com
Whole thread Raw
In response to Re: Cannot drop column  (Viral Shah <viralshah009@gmail.com>)
Responses Re: Cannot drop column
Re: Cannot drop column
List pgsql-general
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.

Regards,

Rich



pgsql-general by date:

Previous
From: Viral Shah
Date:
Subject: Re: Cannot drop column
Next
From: Rich Shepard
Date:
Subject: Re: Cannot drop column