--set ON_ERROR_STOP=on をつける
psql --set ON_ERROR_STOP=on -U dbuser dbname -f sample.sqlpg_dump -U (user name) --table (table name) (db name) > backup.sql-s -> スキーマだけ
-a -> データだけ
データを戻すには
psql -U (user name) (db name) -f backup.sqlpg_dump -U (user name) (db name) > database.sqlデータを戻すには
psql -U (user name) (db name) -f database.sqlSELECT character_set_name FROM information_schema.character_sets;
character_set_name
--------------------
UTF8
(1 row)