pg_dump without blobs - Mailing list pgsql-general

From Sébastien Boutté
Subject pg_dump without blobs
Date
Msg-id 60e9579c0707151457y6943eaefs4fbf4aeff1baefd1@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump without blobs
List pgsql-general
Hi,

I have a postgressql database with a table containing a bytea field. I
would like to dump without this particulary field in order to improve
dump and restore time.
I try with options : -n public (without -b) but it's always the same,
the dump is huge.

How can i do that ?
Do i have to convert my field bytea to oid ?

Thank you for your help,

Sebastien

pgsql-general by date:

Previous
From: novnov
Date:
Subject: Could not create log file error?
Next
From: novnov
Date:
Subject: Re: Could not create log file error?