pg_dump without blobs

From: Sébastien Boutté <sebastien(dot)boutte(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump without blobs
Date: 2007-07-15 21:57:50
Message-ID: 60e9579c0707151457y6943eaefs4fbf4aeff1baefd1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2007-07-15 22:29:45 Re: Could not create log file error?
Previous Message novnov 2007-07-15 21:36:09 Could not create log file error?