假设我们有一个内部表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)
