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

[john polo]

That could definitely be possible. I have a shapefile with similar 
columns and just about as many rows as the one I am trying to export and 
it's just under 10 GB. I can load it into QGIS, but it obviously slows 
things down.

I hadn't considered any kind of limitation like that. Is the limit one 
imposed by PostGIS Shapefile Import/Export Manager on how large a 
shapefile it will write?


On 3/21/2020 5:24 PM, Martin Davis wrote:
> Is it possible you are simply exceeding the allowable size for a 
> shapefile?  The SHP file is limited to a size of 2 GB.
>
> On Fri, Mar 20, 2020 at 9:35 PM john polo <jpolo at mail.usf.edu 
> <mailto: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 <mailto:postgis-users at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/d81ee5b1/attachment.html>