可以使用多个-t来分割,从而导出多个table.
例如:
E:\cpst\campost\backup\cpost20130630>pg_dump -h 10.142.102.12 -p 8115 -U cpost -a -t acp_item_content -t acp_item_detail -t acp_item_detail_service -t acp_other_income -t dlv_mail -t dlv_mail_charge -t dlv_process --inserts -f 022001_acp_dlv_20130630.sql
E:\cpst\campost\backup\cpost20130630>pg_dump -h 10.142.102.12 -p 8116 -U cpost -a -t acp_item_content -t acp_item_detail -t acp_item_detail_service -t acp_other_income -t dlv_mail -t dlv_mail_charge -t dlv_process --inserts -f 023000_acp_dlv_20130630.sql
阅读(17682) | 评论(0) | 转发(0) |