Postgres Pro
Downloads
Home   >   mailing lists

dump and restore a single table containing large objects - Mailing list pgsql-general

From John Liu
Subject dump and restore a single table containing large objects
Date
Msg-id D4FA1B1F848BAF409ED2E4A25831F4C50D6BB9@exchange.STIHealthcare.local
Whole thread Raw
List pgsql-general
Tree view 
Is there a clean way to dump/restore a single table which contains large
objects instead of the entire DB?
In Pg version=7.4 -
pg_dump: Large object output is not supported for a single table.
pg_dump: Use all tables or a full dump instead.

Does version 8.0's pg_dump support a single table dump containing Lo?

Thanks.
John

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: restarting after power outage
Next
From: Jon Lapham
Date:
Subject: Re: restarting after power outage