We can also use "COPY" to export and import tables from and to database.

Export

copy (select * from c_order where period=2009 and org <> 'A') to '/full/path/filename';

Import

copy c_order from 'full/path/filename';