Copy data from table using psql (AWS Redshift) Jul 20, 2016 Assuming both tables have the same fields: insert into table select * from another_table;