Re: Bytea and pg_dump/dumpall - Mailing list pgsql-novice

From John DeSoi
Subject Re: Bytea and pg_dump/dumpall
Date
Msg-id D398831A-E7DB-4544-A8DE-FC31B7BC4623@pgedit.com
Whole thread Raw
In response to Bytea and pg_dump/dumpall  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question regarding pg_restore
Next
From: Tom Lane
Date:
Subject: Re: Bytea and pg_dump/dumpall