Re: pg_dump without blobs

["Sébastien Boutté" <sebastien.boutte@xxxxxxxxx>]

I use version 8.2.4 since last week end in my production database.
I don't want to do a per table dump (I have more than 300 tables).
It's not maintainable as the schema evolves regulary.


On 7/16/07, Francisco Reyes <lists@xxxxxxxxxxxxxxxx> wrote:
> Sébastien Boutté writes:
>
> > I understand that i cannot do a dump of a database without bytea
> > values.
>
> What version of postgresql?
> If 8.2 uou can  do a copy to with a subselect
> copy (select with fields except bytea) to '/somepath';