On Sun, Apr 6, 2008 at 4:25 PM, Mag Gam <magawake(at)gmail(dot)com> wrote:
> What is the best way to dump a database?
>
> 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.
See the format argument to pg_dump. It allows binary dumps.
Sean