[Postgres] Select 하면서 새로운 table 에 insert 하기

CREATE TABLE new_table AS 
SELECT column1, column2, column3 
FROM original_table;

ex)

CREATE TABLE backup_member AS 
SELECT id, name, age
FROM member;
---
CREATE TABLE backup_member_all_columns AS 
SELECT *
FROM member;