| 64 | | select r.gid, c.gid as c_gid, art_11_13/catchment_area as psurf, c.the_geom |
| 65 | | from ccm21.riversegments r |
| 66 | | join ccm21.catchments c on c.wso1_id=r.wso1_id |
| 67 | | where r.wso_id in (select wso_id from france.wso where area='France'); |
| | 64 | C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\p_surf_urb_up" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 select r.gid, c.gid as c_gid, up_art_11_13/up_catchment_area as psurf, c.the_geom from ccm21.riversegments r join ccm21.catchments c on c.wso1_id=r.wso1_id where r.wso_id in (select wso_id from france.wso where area='France'); |
