postgres error: column doesn't exist error in Postgesql 11.6

Question

I am trying to run an update command on postgresql 11.6 by below syntax

 update "YP_SUPPLIERS" set "YP_SUPPLIERS.supplierName" = "update" where "YP_SUPPLIERS.supplierID" = da68e9d0-1100-43e2-0011-db8fbe654321;

I am getting this below error

ERROR:  column "YP_SUPPLIERS.supplierID" does not exist

LINE 1: ... set "YP_SUPPLIERS.supplierName" = "update" where "YP_SUPPLI...

tired different combinations by only giving the column name , removing the quotes but nothing seems to be working.

Could any one suggest me a right way to do it.

You should really avoid those dreaded quoted identifiers. They are much more trouble than they are worth it. wiki.postgresql.org/wiki/… — user330315
– user330315, Commented Jul 23, 2020 at 6:31

user330315 · Accepted Answer · 2020-07-23 06:31:10Z

2

You need to quote each element separately, and the table does not need to be repeated for the target column. String constants need to be enclosed in single quotes (') in SQL. Double quotes are only for identifiers.

 update "YP_SUPPLIERS" 
     set "supplierName" = 'update' --<< single quotes for constant values
 --     ^ no table name here
 where "YP_SUPPLIERS"."supplierID" = 'da68e9d0-1100-43e2-0011-db8fbe654321';
 --    ^ schema and table name must be quoted separately

answered Jul 23, 2020 at 6:31

user330315

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

2 Comments

sumanth shetty Over a year ago

It worked. Why is this so complicated is there any other way to do this ?

user330315 Over a year ago

It's not complicated at all. You made it complicated when you created your tables with quoted identifiers. If you never use double quotes in SQL, you will have a lot less trouble in the long run.

Collectives™ on Stack Overflow

postgres error: column doesn't exist error in Postgesql 11.6

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related