ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query
If you define the columns with double quotes, then you generally need to use them when you refer to the column:
insert into tester3 ("UN0", "UN1") values ( 1, 'jishnu1');I would suggest you remove the double quotes from the column names in the CREATE TABLE statement.
You don't need the double quotes if the name is all lower case.
try this using double quotes to your column names
insert into tester3 ("UN0", "UN1") values ( 1, 'jishnu1');
i have my story with my database for Qgis + POSTGRES DATAi try update my table with code by NavicateUPDATE "MangLuoi"."A_Lam_D310" SET "MangLuoi"."A_Lam_D310"."Nguon"='Lâm'and ERRO :SQL]UPDATE "MangLuoi"."A_Lam_D310" SET "MangLuoi"."A_Lam_D310"."Nguon"='Lâm'
[Err] ERROR: column "MangLuoi" of relation "A_Lam_D310" does not existLINE 1: UPDATE "MangLuoi"."A_Lam_D310" SET "MangLuoi"."A_Lam_D310"."...
Now i tryUPDATE "MangLuoi"."A_Lam_D310" SET "Nguon"='Lâm'
IT show ok :))by Message:Time: 0.035s
Affected rows: 29
Thank for share and answer.