[gdal-dev] Export multiples postgres-tables with an order of fields

[BSAP ( Andres Thomas )]

>>… i’ve tried, but there are several tables to be exported…. I can’t write –select table1.fid,table1.color,table2.fid,table2.mysize,etc…

Now I create mutliples itf’s:

 

ogr2ogr -f "Interlis 1" /itf/table1.itf,myili.ili PG:"dbname='mydb' host='localhost' port='5432' user='postgres' password='pwd'" topic1__table1 -select attr1,attr3,attr2

ogr2ogr -f "Interlis 1" /itf/table2.itf,myili.ili PG:"dbname='mydb' host='localhost' port='5432' user='postgres' password='pwd'" topic1__table2 -select attr3,attr5,attr2

ogr2ogr -f "Interlis 1" /itf/table3.itf,myili.ili PG:"dbname='mydb' host='localhost' port='5432' user='postgres' password='pwd'" topic1__table3 -select attr2,attr3,attr1

 

… then I append them to one itf manually… because the –append option seems not to work with the interlis-driver

 

Is there a better way to do? Couldn’t I use multiples –select options for the different tables into one pg-export?

Greetz, Thomas

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20110920/d9e21d68/attachment.html