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

[Even Rouault]

Le mardi 10 janvier 2012 01:43:40, Jeremy Palmer a écrit :
> I knew I was missing something!
> 
> I've now noticed that empty fields within the CSV get populated as a
> literal '' rather than null. Is there any option to control this behavior
> as well?

Not that I'm aware of.

You can perhaps just issue a "UPDATE test_1 SET yourcolumn = NULL WHERE 
yourcolumn = ''" as a post-processing step ?

> 
> Thanks again,
> Jeremy
> 
> > -----Original Message-----
> > From: Even Rouault [mailto:even.rouault at mines-paris.org]
> > Sent: Tuesday, 10 January 2012 11:24 a.m.
> > To: gdal-dev at 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,
> > > 
> > > 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_actions TEXT,
> > >   land_district VARCHAR(100) NOT NULL,
> > >   titles TEXT,
> > >   survey_area numeric(20,4),
> > >   calc_area numeric(20,4) NOT NULL,
> > >   shape geometry,
> > >   PRIMARY KEY (id)
> > > 
> > > );
> > > 
> > > I'm trying to append data from a CSV file into a pg database but I'm
> > > having problems:
> > > 
> > > ogr2ogr -append -f PostgreSQL "PG:host=xxxx dbname=xxxx" test1.vrt -nln
> > > test_1
> > 
> > Try adding the -preserve_fid option of ogr2ogr.
> 
> ###########################################################################
> ##########
> 
> This message contains information, which is confidential and may be subject
> to legal privilege. If you are not the intended recipient, you must not
> peruse, use, disseminate, distribute or copy this message. If you have
> received this message in error, please notify us immediately (Phone 0800
> 665 463 or info at linz.govt.nz) and destroy the original message. LINZ
> accepts no responsibility for changes to this email, or for any
> attachments, after its transmission from LINZ.
> 
> Thank You.
> 
> ###########################################################################
> ##########