[postgis-devel] DBF-Column type boolen and date

strk at refractions.net strk at refractions.net
Wed Jan 11 07:39:08 PST 2006


[included postgis-devel]

Thanks, here is (one of) the problem(s):

The input has this form:

Id         : 1
Date       : 20051130
Bool       : T

This is safely imported in 'date' and 'bool' fields.

When exported, postgresql returns this:

Id         : 1
Date       : 2005-11-30
Bool       : t

Attached is the output of pgsql2shp (after shp2pgsql).
Does your reader chokes ? Please try multiple readers
if you do have them.

The problem (if it is a problem at all) is that
we use canonical output of every attribute w/out doing
any particular check, when exporting. So if the DBF
format specification expects a specific format for
dates and boolean we'll need to add a post processing
based on type.

--strk;

-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg_test2.zip
Type: application/x-zip-compressed
Size: 959 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060111/a33fda98/attachment.bin>


More information about the postgis-devel mailing list