SQL update fields of one table from fields of another one

by

You can use the non-standard FROM clause.

UPDATE b
SET column1 = a.column1,
  column2 = a.column2,
  column3 = a.column3
FROM a
WHERE a.id = b.id
AND b.id = 1

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. Refactor a PL/pgSQL function to return the output of various SELECT queries
  3. updating table rows in postgres using subquery
  4. PostgreSQL parameterized Order By / Limit in table function
  5. Return pre-UPDATE column values using SQL only
  6. Casting NULL type when updating multiple rows
  7. Slow simple update query on PostgreSQL database with 3 million rows
  8. DROP FUNCTION without knowing the number/type of parameters?
  9. PostgreSQL convert columns to rows? Transpose?
  10. Bulk/batch update/upsert in PostgreSQL
  11. COPY with dynamic file name
  12. Postgres error updating column data
  13. Update a column of a table with a column of another table in PostgreSQL
  14. Functions with variable number of input parameters
  15. Create PostgreSQL ROLE (user) if it doesn’t exist
  16. PostgreSQL – dynamic value as table name [duplicate]
  17. PostgreSQL “Column does not exist” but it actually does
  18. Is SELECT or INSERT in a function prone to race conditions?
  19. Oracle SQL: Update a table with data from another table
  20. SQL UPDATE order of evaluation
  21. Double colon `::` notation in SQL
  22. Window Functions: last_value(ORDER BY … ASC) same as last_value(ORDER BY … DESC)
  23. I keep getting the error “relation [TABLE] does not exist”
  24. Export specific rows from a PostgreSQL table as INSERT SQL script
  25. Which datatype should be used for currency?
  26. How to return two columns with function
  27. Prepared Statement on Postgresql in Rails
  28. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  29. Postgresql query between date ranges
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment