Hi,
I've just been using v.in.db to register points from a PostgreSQL table - it all works nicely except that the pg driver doesn't support converting boolean columns in my pg table into the resulting dbf file (see below for output of v.in.db). This isn't a huge problem because I can just use v.db.connect to connect the vector map back to the original pg table, but v.out.ogr also is unable to export these columns through the pg driver.
I'm using Grass 5.7 built from the 2004_01_10 weekly snapshot and PostgreSQL v. 7.4.1. running under mac OS 10.3.2.
Thanks,
David
GRASS 5.7.-cvs:~ > v.in.db driver=pg database=adhoc table=behr_grid x=e_centre_behr y=n_centre_behr key=grid_id output=behr_grid
54720 points written to vector
WARNING: pg driver: column 'land', type 0 is not supported
WARNING: pg driver: column 'threat_hotspot', type 0 is not supported
WARNING: pg driver: column 'threat_randspot', type 0 is not supported
WARNING: pg driver: column 'richness_hotspot', type 0 is not supported
WARNING: pg driver: column 'richness_randspot', type 0 is not supported
WARNING: pg driver: column 'endemism_hotspot', type 0 is not supported
WARNING: pg driver: column 'endemism_randspot', type 0 is not supported54720 primitives registered
0 areas built 8%
0 isles built
Number of nodes : 54720
Number of primitives: 54720
Number of points : 54720
Number of lines : 0
Number of boundaries: 0
Number of centroids : 0
Number of areas : 0
Number of isles : 0
Vector import complete
GRASS 5.7.-cvs:~ >