ダンプデータ生成時にcopyではなくinsert文を生成するようにする
pg_dump -h ${ホスト} -p ${ポート} -U ${ユーザー名} --inserts -v ${schema名} > ${ファイル名}.sql
参考URL
https://qastack.jp/programming/20427689/psql-invalid-command-n-while-restore-sql
More than 3 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme