postgresql 复制表

1. INSERT INTO FROM 语句

insert into tablebackup select * from table;
insert into tablebackup select field1,field2,field3 from table where ...;

前提：tablebackup 必须存在

2. SELECT INTO FROM 语句

select * into tablebackup from table;
select field1,field2,field3 into tablebackup from table;