Re: best practices for dumping databases

On Sun, Apr 6, 2008 at 4:25 PM, Mag Gam <magawake@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice