[postgis-users] Attribute table with coordinates

[Gabriele de Filippo]

thank you

> On 11 May 2023, at 14:52, Regina Obe <lr at pcorp.us> wrote:
> 
> You should add a PostGIS geometry or geography column as follows
> 
> ALTER TABLE name_of_your_table ADD COLUMN geog geography(POINT,4326);
> 
> UPDATE name_of_your_table SET geog = ST_SetSRID(ST_Point(X, Y),4326)::geography;
> 
> CREATE INDEX ix_name_of_your_table_geog ON name_of_your_table USING gist(geog);
> 
> Then you should see this table appear as a layer option in QGIS
> 
>> -----Original Message-----
>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
>> Of Gabriele de Filippo
>> Sent: Thursday, May 11, 2023 2:57 AM
>> To: postgis-users at lists.osgeo.org
>> Subject: [postgis-users] Attribute table with coordinates
>> 
>> I have a attribute table with X, Y coordinates in a  Postgres database.
>> I’m able to read this database and table in Qgis using Postgis extension, but I
>> don’t know how use the table such a layer.
>> I would use the table such as I use a CSV file in Qgis. Is it possible?
>> Thank you
>> Gabriele
>> _______________________________________________
>> postgis-users mailing list
>> 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