RE: [gdal-dev] How to append data into an existing database table

2012-01-09 Thread Jeremy Palmer
Ah ok. I was hoping to avoid that. > -Original Message- > From: Even Rouault [mailto:even.roua...@mines-paris.org] > Sent: Tuesday, 10 January 2012 1:49 p.m. > To: Jeremy Palmer > Cc: gdal-dev@lists.osgeo.org > Subject: Re: [gdal-dev] How to append data into an exist

Re: [gdal-dev] How to append data into an existing database table

2012-01-09 Thread Even Rouault
mines-paris.org] > > Sent: Tuesday, 10 January 2012 11:24 a.m. > > To: gdal-dev@lists.osgeo.org > > Cc: Jeremy Palmer > > Subject: Re: [gdal-dev] How to append data into an existing database > > table > > > > Le lundi 09 janvier 2012 22:47:21, Jeremy Palmer a écrit

RE: [gdal-dev] How to append data into an existing database table

2012-01-09 Thread Jeremy Palmer
ua...@mines-paris.org] > Sent: Tuesday, 10 January 2012 11:24 a.m. > To: gdal-dev@lists.osgeo.org > Cc: Jeremy Palmer > Subject: Re: [gdal-dev] How to append data into an existing database table > > Le lundi 09 janvier 2012 22:47:21, Jeremy Palmer a écrit : > > Hi All,

Re: [gdal-dev] How to append data into an existing database table

2012-01-09 Thread Even Rouault
Le lundi 09 janvier 2012 22:47:21, Jeremy Palmer a écrit : > Hi All, > > I've got an existing spatial table in PostgreSQL with has an existing > primary key (non-serial) and shape column: > > CREATE TABLE test_1 > ( > id integer NOT NULL, > appellation TEXT, > affected_surveys TEXT, > par

[gdal-dev] How to append data into an existing database table

2012-01-09 Thread Jeremy Palmer
Hi All, I've got an existing spatial table in PostgreSQL with has an existing primary key (non-serial) and shape column: CREATE TABLE test_1 ( id integer NOT NULL, appellation TEXT, affected_surveys TEXT, parcel_intent TEXT NOT NULL, topology_type VARCHAR(100) NOT NULL, statutory_act