Update Redshift table from query


I’m trying to update a table in Redshift from query:

But I receive the following error:


This is completely invalid syntax for Redshift (or Postgres). Reminds me of SQL Server …

Should work like this (at least on current Postgres):

This is generally the case for Postgres and Redshift:

  • Use a FROM clause to join in additional tables.
  • You cannot table-qualify target columns in the SET clause.

Also, Redshift was forked from PostgreSQL 8.0.2, which is very long ago. Only some later updates to Postgres were applied.

I simplified some other details.

Leave a Reply