pg导出导入copy格式的数据

导出
pg_dump -U [username] -h [host] -p [port] -t [tablename] -f /tmp/file.sql [database]

导入
D:\Program Files (x86)\PostgreSQL\9.5\bin>psql.exe -U postgres -f in.sql dbname