Update field named 'from' in table postgres [duplicate]

Question

I need to update field named 'from' in postgres. But i can not to do it.

Select working such:

SELECT table_name.from FROM table_name WHERE id=1

But I can not do it with UPDATE:

production=# UPDATE table_name SET from='text' WHERE id=3482; ERROR: syntax error at or near "from" production=# update table_name set table_name.from='text' where id=3482; ERROR: column "table_name" of relation "table_name" does not exist LINE 1: update table_name set table_name.from='

Can you suggest a way to update a field 'from' in the table?

Have you tried using quotes around the from (like SELECT table_name."from" FROM table_name WHERE id=1) — Nico Haase
– Nico Haase, Commented Jul 19, 2021 at 11:31
See stackoverflow.com/questions/7651417/… for more details — Nico Haase
– Nico Haase, Commented Jul 19, 2021 at 11:31
Its not working ERROR: column "table_name" of relation "table_name" does not exist or ERROR: syntax error at or near "'from'" LINE 1: update table_name set table_name.'from'= — Vlad Kn
– Vlad Kn, Commented Jul 19, 2021 at 11:34
Mandatory read: Identifiers and Keywords in the Postgres manual — user330315
– user330315, Commented Jul 19, 2021 at 11:34
O! Its working! production=# update "table_name" set "from"='text' where id=3482; UPDATE 1 Thanks! — Vlad Kn
– Vlad Kn, Commented Jul 19, 2021 at 11:40

EcksDy · Accepted Answer · 2021-07-19 11:35:31Z

0

Use double quotes as such:

UPDATE table_name SET "from"='text' WHERE id=3482;

Look at 4.1.1. Identifiers and Key Words for more info.

edited Jul 19, 2021 at 11:35

user330315

answered Jul 19, 2021 at 11:31

EcksDy

1,72417 silver badges31 bronze badges

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

Comments

Shashank Adhatrao · Accepted Answer · 2021-07-19 11:46:29Z

-2

Change "from" to Your "Field Name"
UPDATE table_name SET "from" = value1 where id=1

edited Jul 19, 2021 at 11:46

answered Jul 19, 2021 at 11:34

Shashank Adhatrao

776 bronze badges

2 Comments

Nico Haase Over a year ago

Please share more details. I would assume that from is the name of the column

user330315 Over a year ago

The column is named from - that's the problem

Collectives™ on Stack Overflow

Update field named 'from' in table postgres [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related