Currently, I am using pg_dump dbname. However, my data contains a lot of escape sequences and various characters which is causing a restore problem. How can I avoid problems like this? Is there a "binary" dump and restore? I rather use that if its going to guarantee valid data.
