Column doesnot exist error in PostgreSQL command

Question

I have been trying to get the result of a PostgreSQL command. I am getting the following error. I want to get the video id, video name and the created date for that specific video.

I have all the required columns in the table as shown below:

Another good example why you shouldn't use mixed case or upper case identifiers. If you never use double quotes (including the CREATE TABLE statements), then you don't have this problem. — user330315
– user330315, Commented Nov 17, 2021 at 7:39

Laurenz Albe · Accepted Answer · 2021-11-17 07:31:02Z

2

If you write "tablename.columnname", that is not interpreted as table name and column name, but as a single identifier. Based on the context in a join condition, PostgreSQL expects it to be a column name.

If you use double quotes, you have to quote column and table separately: "tablename"."columnname"

answered Nov 17, 2021 at 7:31

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Column doesnot exist error in PostgreSQL command

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related