Re: Pg_dump and bytaA

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Pg_dump and bytaA
Date: 2007-03-09 13:05:20
Message-ID: esrm2i$63o$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

Achilleas Mantzios wrote:
> Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
>> Hello,
>>
>> pg_dump can avoid bloob fields (it can dumb without blobs), but as I
>> understand byteA is not bloob, so in this case what is blob? I did not
>> found such type as blob..
>>
>
> Take a look at
> http://www.postgresql.org/docs/7.4/interactive/largeobjects.html
>
> You might also consider writing a program for transforming your db/app
> from bytea based to large object based, and simply exclude blobs
> from your pg_dump's.

How to exclude them from a custom dump? (That's for version 8.1/8.2)

--
Milen A. Radev

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2007-03-09 13:18:03 Re: Pg_dump and bytaA
Previous Message Monika Cernikova 2007-03-09 10:05:14 index bloat problem

Browse pgsql-novice by date

  From Date Subject
Next Message Achilleas Mantzios 2007-03-09 13:18:03 Re: Pg_dump and bytaA
Previous Message Ashish Karalkar 2007-03-09 12:59:19 Re: Help with creating Documentation