Re: [GENERAL] Dumping from older version

2007-09-26 Thread Raymond O'Donnell
On 26/09/2007 16:26, Carlos Moreno wrote: Maybe you used the switch -d to specify the database? (like with psql and some other client applications). Duhhh! I've just realised my mistake - here's my command line: pg_dump -h 192.168.200.2 -U postgres -d assetreg -f assetreg.txt -E utf8 I

Re: [GENERAL] Dumping from older version

2007-09-26 Thread Carlos Moreno
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? I noticed this today when transferring data to a newer server - pg_dump generated INSERTs although I

Re: [GENERAL] Dumping from older version

2007-09-26 Thread Alvaro Herrera
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 INSERT

[GENERAL] Dumping from older version

2007-09-26 Thread Raymond O'Donnell
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? I noticed this today when transferring data to a newer server - pg_dump generated INSERTs although I didn't ask for them. Not a