下面这条语句可以很简单的加载ext_expenses表中的数据到expenses表中。
CREATE TABLE expenses AS SELECT * FROM ext_expenses;
用户也可以通过把建表语句以及加载数据分开:
CREATE TABLE expenses(name text, date date, amount float4, category text, desc1 text); INSERT INTO expenses SELECT * FROM ext_expenses;
