[postgis-users] query a certain row from a table.

Alexander Gataric gataric at usa.net
Sat Mar 21 00:36:24 PDT 2020


What format are the points stored in? Point, multipoint? How many points per row?

⁣Get BlueMail for Android ​

On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo <jpolo at mail.usf.edu> wrote:
>Hi,
>
>I'm trying to export a table of points to a shapefile. The table has 
>over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile 
>Import/Export Manager on Windows 10. When I try to run the export, I 
>keep getting this error:
>
>Error: record 3329432 could not be created
>
>I'm not sure how to handle this. My first impulse is find the offending
>
>row, but I don't know the SQL for such a query. Is there something I 
>need to write in a WHERE clause or a different clause to get a specific
>row?
>
>-- 
>Enlightenment is ego's ultimate disappointment.
>-Chogyam Trungpa
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment.html>


More information about the postgis-users mailing list