As with the table, if you're going to use a SQL keyword, you need to quote it. LINE 1: UPDATE "table" t1 SET t1.column=0 WHERE t1.column2=1234 Īnd that's the problem you're getting. Now we can try your original query and get your original result, UPDATE "table" t1 SET t1.column=0 WHERE t1.column2=1234 ĮRROR: column "t1" of relation "table" does not exist Let's create some text data, CREATE TABLE "table" AS
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |