Search Postgresql Archives

Re: Dumping from older version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux