Re: Bytea and pg_dump/dumpall

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Bytea and pg_dump/dumpall
Date: 2005-09-23 14:07:15
Message-ID: D398831A-E7DB-4544-A8DE-FC31B7BC4623@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-09-23 14:18:22 Re: Bytea and pg_dump/dumpall
Previous Message Tom Lane 2005-09-23 14:04:04 Re: Question regarding pg_restore