Learn how to add geospatial data to PostgreSQL using the PostGIS extension.
1:44 Create table
4:20 Creating INSERT INTO statement
----------------------------------------------------------------------------------------------------------------------------------------------------------------
📄 Code - INSERT INTO public.test VALUES ('Sofia', ST_GeomFromText('Point(23.319941 42.69833)', 4326))
📖 WKT - https://es.wikipedia.org/wiki/Well_Kn...
📖 Add geometry from the text - https://postgis.net/docs/ST_GeomFromT...
💻 Platform - https://www.postgresql.org/
🎶 Music by RelaxingTime from Pixabay.
Install PostgreSQL on Windows - • PostgreSQL: How to download & install Post...
Install PostGIS on Windows- • PostgreSQL Tutorial: How to download and i...
----------------------------------------------------------------------------------------------------------------------------------------------------------------
You can also follow me here:
GitHub - https://github.com/Ponsoda/
Twitter - / _ponsoda_
Linkedin - / ignponsoda
----------------------------------------------------------------------------------------------------------------------------------------------------------------
#tutorial #GeoProgramming #postgresql #postgis