OushuDB-准备导出的表

假设我们有一个内部表expenses如下:
CREATE TABLE myexpenses(name text, date date, amount float4, category text, desc1
text);
INSERT INTO myexpenses VALUES('john','2017-01-20',100.00,'travel','nothing'),
('tom','2016-12-01',300,'taxi','nothing');
INSERT INTO myexpenses VALUES('marry','2017-01-21',1000.00,'travel','nothing'),
('kurt','2016-12-02',800,'taxi','nothing');
etl=# select * from myexpenses;

name	date	amount	category	desc1
john	2017-01-20	100	travel	nothing
tom	2016-12-01
marry	2017-01-21
kurt	2016-12-02

(4 rows)