create table as select * from orgi_table order by .. limit 1000
copy(select * from orgi_table order by .. limit 1000) to 'csv.file
您可以在查询中使用COPY命令,例如:
COPY
COPY (SELECT a.id, a.name FROM a ORDER BY a.id LIMIT 100) TO 'a.txt';
create table as select * from orgi_table order by .. limit 1000
orcopy(select * from orgi_table order by .. limit 1000) to 'csv.file
- Vao Tsun