Re: Dumping from older version - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Dumping from older version
Date
Msg-id 20070926152218.GF8572@alvh.no-ip.org
Whole thread Raw
In response to Dumping from older version  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Raymond O'Donnell wrote:
> Just wondering - when using a newer pg_dump to dump from an older Postgres,
> does pg_dump automatically generate INSERT statements for the data rather
> than using COPY?

No.

> I noticed this today when transferring data to a newer server - pg_dump
> generated INSERTs although I didn't ask for them. Not a problem, but I was
> curious.

Perhaps you included -d in the command line options?

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PG_DUMP not working
Next
From: Bill Moran
Date:
Subject: Re: Help tuning a large table off disk and into RAM