Tag Archives: update

postgresql中从多表中进行update

Posted on 2011-12-11 by wlx

有时候，需要根据其他表的数据对某表的数据进行更新，这是就可以用到多表更新的功能： update metadata m set source=s.uuid from source s right join datasource d on s.id=d.sourceid where m.uuid=d.uuid

Posted in Program | Tagged , , | Leave a comment

gdal.sh自动更新安装

Posted on 2004-11-24 by wlx

为了gdal更新的方便，写了一个简单的shell脚本： cd /root/gdal/ cvs update ./configure –with-hdf4 –with-netcdf –with-pg=/usr/local/pgsql/bin/pg_config –with-geos –with-libtiff=internal –with-static-proj4 –with-grass=/usr/local/grass-5.7.cvs make clean make make install

Posted in Computer, GIS, RS | Tagged , , , | Leave a comment