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