Question: how to copy data from one column to another in postgresql?
Answer: Use the 'UPDATE' SQL Keyword to Copy the Contents of a PostgreSQL Column. UPDATE some_table SET col_NEW = col_str; This statement should return a response saying UPDATE , followed by an integer value indicating the number of records that were copied (e.g. UPDATE 3 ).