sql UPDATE, SET

gistfile1.sql

execute <<-SQL
  UPDATE contacts
  SET country =
  CASE
  WHEN country = 'USA' THEN 'United States'
  WHEN country = 'Russia' THEN 'Russian Federation'
  WHEN country = 'Virgin Islands' THEN 'Virgin Islands, U.S.'
  END
  WHERE country in ('USA', 'Russia', 'Virgin Islands')
SQL