CODEWITHSUNDEEP
sqlpostgresqlquoted-identifier
Smile Kisan
Smile Kisan

Reputation: 321

Column doesnot exist error in PostgreSQL command

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. enter image description here

I have all the required columns in the table as shown below: enter image description here

enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 433

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 248305

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"

Upvotes: 2

Related Questions