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

[John Polo]

They are stored as Point. One per row.



On Saturday, March 21, 2020, Alexander Gataric <gataric at usa.net> wrote:

> What format are the points stored in? Point, multipoint? How many points
> per row?
>
> Get BlueMail for Android <http://www.bluemail.me/r?b=15824>
> On Mar 20, 2020, 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?
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment.html>