Postgres Pro
Downloads
Home   >   mailing lists

Thread: Bytea and pg_dump/dumpall

Bytea and pg_dump/dumpall

From
Sean Davis
Date:
Just a quick question:

Bytea columns are backed up appropriately using pg_dump/dumpall?  The docs
mention specifics about large objects, and I just wanted to check whether
bytea is considered a large object in regard to backup.

Thanks,
Sean

Re: Bytea and pg_dump/dumpall

From
John DeSoi
Date:
On Sep 23, 2005, at 7:11 AM, Sean Davis wrote:

> Bytea columns are backed up appropriately using pg_dump/dumpall?
> The docs
> mention specifics about large objects, and I just wanted to check
> whether
> bytea is considered a large object in regard to backup.

Yes, bytea columns are dumped/restored as any other column type.
Large objects are a different type created using a separate API:

http://www.postgresql.org/docs/8.0/interactive/largeobjects.html



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

Re: Bytea and pg_dump/dumpall

From
Tom Lane
Date:
Sean Davis <sdavis2@mail.nih.gov> writes:
> Bytea columns are backed up appropriately using pg_dump/dumpall?  The docs
> mention specifics about large objects, and I just wanted to check whether
> bytea is considered a large object in regard to backup.

bytea is just data.

            regards, tom lane