hi this is suvarnaraju from india<pre lang="c#">
this solution is ok to convert prostgres table to shapedata
string simbol = "\"";
System.Diagnostics.Process process = new System.Diagnostics.Process();
System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo();
//startInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
startInfo.FileName = "C:\\Program Files (x86)\\pgAdmin III\\1.14\\bin\\pgsql2shp.exe";
//startInfo.FileName = "D:\\suvarnaraju\\pgsql2shp.exe";
startInfo.Arguments = "-f " + simbol + "D:\\suvarnaraju\\smallpoly.shp" + simbol + " -h 172.16.45.45 -u sxd -P sxd momacpp_213_live " + simbol + "SELECT id, orig_evidence_id, orig_database_id, partition_ref_id, dataset_ref_id,morton_code,max_road_class, confidence_hsp, status_id, status_update_user,status_update_timestamp, checkout_lock, guid, area_index,longitude,latitude, project_id,ST_GEOMFROMTEXT('LINESTRING(-122.17675841345 47.5835549758457,-122.176540306996 47.9954608782427,-122.47782707008426 48.781405510842475,-101.12792269989149 39.788612687934005,-92.8553282080493 38.9352617503735,-73.9429490726049 40.848649244561,-77.05900691901427 37.80297740209517)') FROM workflow.evidence_to_do limit 100" + simbol + "";
startInfo.UseShellExecute = false;
process.StartInfo = startInfo;
process.Start();