While importing I get this error:
pg_restore: [archiver (db)] COPY failed for table "transaction_details": ERROR: invalid input syntax for type money: "$0.00"
restore
completed, but the transaction_details
table is empty.
This is Heroku's PostgreSQL Dump database.
PostgreSQL version on Heroku is 9.3.15 and the same on my system
The command I used:
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U root -d database 577b86e3-8d96-4410-9b36-dd0f78cfe32f
Could anyone suggest a solution?
money
type. It's terrible. Switch to usingnumeric
.