ERROR: invalid input syntax for type money

7 votes

1 answer

7012 views

postgresql restore postgresql-9.3 pg-restore money

                          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?

Asked by Akash Kumar (83 rep)

Dec 30, 2016, 02:29 AM
Last activity: Dec 30, 2016, 03:33 PM

ERROR: invalid input syntax for type money

Related Questions