Re: backup compress...blobs/insert commands/verbose - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: backup compress...blobs/insert commands/verbose
Date
Msg-id 1115681680.24340.9.camel@localhost.localdomain
Whole thread Raw
In response to backup compress...blobs/insert commands/verbose messages  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
[note: it is better to create a new thread than to hijack an
       unrelated one]

On Mon, 2005-05-09 at 18:45 +0200, Zlatko Matic wrote:
> Can someone explain me the following options while using pgAdimn III for
> backup:
>
my guess is...

> blobs
include blobs in backup. blobs are not included
by default (I think)

> insert commands
text file backups create a file containing a series
of SQL commands. data is imported with COPY, which is effective,
but you might prefer a series of INSERT commands, if you want to
keep it more portable between database systems, or need to
import it into old postgresql versions.

gnari

[snip quote of an entire unrelated email]




pgsql-general by date:

Previous
From: Bart Grantham
Date:
Subject: Array manipulation/syntax question
Next
From: Neil Conway
Date:
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL