PostgreSQL 16: cannot drop a tsvector column

Question

I have the IMDB database in PostgreSQL 16, with the table title_basics. The table contains several columns, including titleSearchCol which is of type tsvector. When I try to get rid of the column using psql with

ALTER TABLE title_basics DROP COLUMN titleSearchCol;

PostgreSQL throws an error

ERROR: column "titlesearchcol" of relation "title_basics" does not exist

I can query the table, add more columns and drop other columns using the same syntax just fine. I have tried the postgres superuser as well, resulting in the same error message.

Querying the table with SELECT *... shows the column and its contents. \d title_basics also shows the column.

imdb_base=> \d title_basics

Table "public.title_basics"
Column        Type               Collation Nullable Default
-----------------------------------------------------------
tconst         character varying           not null
titletype      character varying
primarytitle   character varying
originaltitle  character varying
isadult        boolean
startyear      numeric
endyear        numeric
runtimeminutes character varying
genres         character varying
titleSearchCol tsvector

Indexes:
"title_basics_pk" PRIMARY KEY, btree(tconst)

Referenced by:                                                     
TABLE "title_akas" CONSTRAINT "title_akas_title_basics_fk" FOREIGN KEY (titleid) REFERENCES title_basics(tconst) NOT VALID
TABLE "title_crew" CONSTRAINT "title_crew_title_basics_fk" FOREIGN KEY (tconst) REFERENCES title_basics(tconst) NOT VALID
TABLE "title_episode" CONSTRAINT "title_episode_title_basics_fk" FOREIGN KEY (parenttconst) REFERENCES title_basics(tconst) NOT VALID
TABLE "title_principals" CONSTRAINT "title_principals_title_basics_fk" FOREIGN KEY (tconst) REFERENCES title_basics(tconst) NOT VALID
TABLE "title_ratings" CONSTRAINT "title_ratings_title_basics_fk" FOREIGN KEY (tconst) REFERENCES title_basics(tconst) NOT VALID

Answer 1

As you can see, there's no column titlesearchcol, but there are column titleSearchCol. Someone had created that column with capital letters in name (using quotes), and now it only possible to use that column using quotes, like that: ALTER TABLE title_basics DROP COLUMN "titleSearchCol";