Microsoft SQL Server versus Postgres Spatial

Question

I currently work with Postgres database with the Spatial component installed is there a difference in spatial functionality between Postgres with Spatial and the latest Microsoft SQL Server version?

What problems do you have that you think will be solved with SQL Server? — user330315
– user330315, Commented Oct 3, 2018 at 7:01
Our company use at this moment PostGres for building shapes and geo map layers. We use therefor the GeoSpatial modulle within Postgres. The plan is to move to the Microsoft Azure and work with Azure SQL Database. But i don't know what the impact on functional level. — Erik hoeven
– Erik hoeven, Commented Oct 3, 2018 at 10:01
You can get Postgres (not PostGres) on Azure as well: azure.microsoft.com/en-us/services/postgresql (I assume you are referring to PostGIS when you talk about "geo spatial module2?) — user330315
– user330315, Commented Oct 3, 2018 at 10:05

Rémi Desgrange · Accepted Answer · 2018-10-03 11:33:01Z

1

There are slight difference, basic function are the same (st_distance, st_equal). Postgis have some function that SQL Server doesn't have (like st_clusterkmeans). Sql server function are named STXXX, where postgis function are named ST_XXX.

So in term of function you'll not be lost, bu in term of SQL, postgres use PLpgSQL where SQL Server use T-SQL. You can see example of sql server basic request here

answered Oct 3, 2018 at 11:33

Rémi Desgrange

9381 gold badge8 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user330315 Over a year ago

Postgres doesn't "use" PL/pgSQL - Postgres (unlike SQL Server) makes a clear distinction between the query language (SQL) and procedural language. Queries (DML, DDL) are written in SQL - stored function can be written in PL/pgSQL (or SQL or Python or JavaScript or ....)

Erik hoeven Over a year ago

Thanks for your answers

Rémi Desgrange Over a year ago

@a_horse_with_no_nameyou're right the term "use" was not appropriate here.

Collectives™ on Stack Overflow

Microsoft SQL Server versus Postgres Spatial

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related