I am trying to restore a database from a pg_dump.
I have a problematic issue in that a few rows have a problem with UTF-8 encoding.
All of these rows are in a specific table.
Is there something I can run against the table which will validate the rows which have the bad data and delete the rows?
The database is quite large (8GB) and I was informed that it would be much faster to restore using the COPY method as opposed to the INSERT method.
Any and all assistance will be deeply appreciated.
Regards,
Benjamin