Re: pg_dump without blobs

Vivek Khera wrote:
>
> On Jul 16, 2007, at 9:26 AM, Francisco Reyes wrote:
>
>> I guess the next question is 'what does postgresql considers a blob'?
>> bytea fields? How about a large text with megabytes worth of data?
>
> bytea and text fields are NOT blobs. they are what you access via the
> 'large object' functions.

To follow up on this.

In oracle large text CLOB and binary objects BLOB are synonomous (I
believe) with PostgreSQL TEXT and BYTEA.

PostgreSQL also supports a non standard, and frankly better
implementation called lo for binary data, which also uses BYTEA data but
breaks it up to make it more efficient per row.

There is no way to "not" dump your TEXT and BYTEA data from a particular
column if you are dumping the whole table.

One option would be to use CREATE TEMP TABLE AS SELECT... and then dump
that temp table.

Joshua D. Drake

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/