thank you > On 11 May 2023, at 14:52, Regina Obe <[email protected]> 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:[email protected]] On Behalf >> Of Gabriele de Filippo >> Sent: Thursday, May 11, 2023 2:57 AM >> To: [email protected] >> 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 >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
