NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
:: SQL view or table name
If you would like to export all rows then you refer to the SQL view/table by the name of it.<br/>
If you would like to export only some rows then you need to add more SQL statements.
{{Note | Any " inside the SQL statement needs to be escaped and therefore it is easier to refer to a SQL view that contains the columns and rows you would like to export.<br/>Example: <nowiki>pgsql2shp -f land_polygon -h localhost -u imsma -P password staging " select * from haz_gis_poly where \"Status\" = 'Closed' " </nowiki>}}
[[Image:Pgsql2shp.png|600px|center]]<br/>
'' The number of rows exported will be shown when the export is done ''
</div>
{{Note | If the Output shape type is '''''Unknown''''' or '''''Null'''''then there is something wrong with the SQL view/table. Most likely the mandatory column ''shape'' is '''not''' included.}}
{{NavBox AGOL Extension}}
[[Category:NAA]]
