ダンプ
db=# copy(select * from table_name where id > 320) to '/home/username/db_dump_20161011.dump';
COPY 20
ダンプしたデータの投入
copy句だと怒られる。
db=> copy sample_table from '/home/username/db_dump_20161011.dump';
ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone.
取り急ぎ\copyで実行
db=> \copy sample_table from '/home/username/db_dump_20161011.dump';
COPY 56