<div dir="ltr">SELECT *<br>FROM<br> (SELECT *,<br> row_number() OVER () AS NumLigne<br> FROM TaTable<br> ) AS TaTableAvecNumLigne<br>WHERE NumLigne = 3329432;</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le sam. 21 mars 2020 à 20:01, <<a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send postgis-users mailing list submissions to<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:postgis-users-owner@lists.osgeo.org" target="_blank">postgis-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. query a certain row from a table. (john polo)<br>
2. Re: query a certain row from a table. (Alexander Gataric)<br>
3. Re: query a certain row from a table. (John Polo)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 20 Mar 2020 21:35:21 -0700<br>
From: john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: [postgis-users] query a certain row from a table.<br>
Message-ID: <<a href="mailto:d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu" target="_blank">d05371ca-fcf0-d3e7-c85f-42f144a9132a@mail.usf.edu</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
Hi,<br>
<br>
I'm trying to export a table of points to a shapefile. The table has <br>
over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile <br>
Import/Export Manager on Windows 10. When I try to run the export, I <br>
keep getting this error:<br>
<br>
Error: record 3329432 could not be created<br>
<br>
I'm not sure how to handle this. My first impulse is find the offending <br>
row, but I don't know the SQL for such a query. Is there something I <br>
need to write in a WHERE clause or a different clause to get a specific row?<br>
<br>
-- <br>
Enlightenment is ego's ultimate disappointment.<br>
-Chogyam Trungpa<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sat, 21 Mar 2020 02:36:24 -0500<br>
From: Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] query a certain row from a table.<br>
Message-ID: <<a href="mailto:5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net" target="_blank">5c4820aa-f60d-4b7e-9ca1-45da6a8d416a@usa.net</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
What format are the points stored in? Point, multipoint? How many points per row?<br>
<br>
Get BlueMail for Android <br>
<br>
On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:<br>
>Hi,<br>
><br>
>I'm trying to export a table of points to a shapefile. The table has <br>
>over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile <br>
>Import/Export Manager on Windows 10. When I try to run the export, I <br>
>keep getting this error:<br>
><br>
>Error: record 3329432 could not be created<br>
><br>
>I'm not sure how to handle this. My first impulse is find the offending<br>
><br>
>row, but I don't know the SQL for such a query. Is there something I <br>
>need to write in a WHERE clause or a different clause to get a specific<br>
>row?<br>
><br>
>-- <br>
>Enlightenment is ego's ultimate disappointment.<br>
>-Chogyam Trungpa<br>
><br>
>_______________________________________________<br>
>postgis-users mailing list<br>
><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/b1b44f20/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Sat, 21 Mar 2020 08:06:34 -0700<br>
From: John Polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] query a certain row from a table.<br>
Message-ID:<br>
<<a href="mailto:CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm%2BpSsCB-ww@mail.gmail.com" target="_blank">CALTSVX9DsHew5rm2kbxjTQjDYo11Y9b_xHpy8D7Pm+pSsCB-ww@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
They are stored as Point. One per row.<br>
<br>
<br>
<br>
On Saturday, March 21, 2020, Alexander Gataric <<a href="mailto:gataric@usa.net" target="_blank">gataric@usa.net</a>> wrote:<br>
<br>
> What format are the points stored in? Point, multipoint? How many points<br>
> per row?<br>
><br>
> Get BlueMail for Android <<a href="http://www.bluemail.me/r?b=15824" rel="noreferrer" target="_blank">http://www.bluemail.me/r?b=15824</a>><br>
> On Mar 20, 2020, at 11:36 PM, john polo <<a href="mailto:jpolo@mail.usf.edu" target="_blank">jpolo@mail.usf.edu</a>> wrote:<br>
>><br>
>> Hi,<br>
>><br>
>> I'm trying to export a table of points to a shapefile. The table has<br>
>> over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile<br>
>> Import/Export Manager on Windows 10. When I try to run the export, I<br>
>> keep getting this error:<br>
>><br>
>> Error: record 3329432 could not be created<br>
>><br>
>> I'm not sure how to handle this. My first impulse is find the offending<br>
>> row, but I don't know the SQL for such a query. Is there something I<br>
>> need to write in a WHERE clause or a different clause to get a specific row?<br>
>><br>
>><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20200321/3c2986ce/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 217, Issue 15<br>
**********************************************<br>
</blockquote></div>