Postgis: Support Geometry data type

[tordans]

We are using PostGIS in PostgreSQL to handle geodata.
It looks like the Geometry data type is not supported.
https://postgis.net/docs/using_postgis_dbmanagement.html#OGC_Geometry

["ERROR" - 17:25:00] Error formatting document.
["ERROR" - 17:25:00] Syntax Error: Unexpected "Geometry"
Was expecting to see: "DATE", "DATETIME", "FALSE", "INTERVAL", "JSON", "JSONB", "NULL", "TIME", "TIMESTAMP", "TRUE", "X", "b", number, string, or whitespace
--> /Users/fmc/Development/tilda-geo/processing/topics/parking/punching_areas.sql:42:34
   |
42 | ALTER COLUMN geom TYPE geometry (Geometry, 5243) USING ST_SetSRID (geom, 5243);
   |      

Testcase: https://nene.github.io/prettier-sql-playground/

Input

ALTER TABLE parking_punching_areas
ALTER COLUMN geom TYPE geometry (Geometry, 5243) USING ST_SetSRID (geom, 5243);

[nene]

Thanks for reporting. Could you explain this type to me:

geometry (Geometry, 5243)

I understand that geometry is the name of the type, and Geometry is some sort of parameter to that type. Aha... I see some other examples like:

geometry(Polygon, 3395)
geometry(POINT,4326)
geometry(POINT)
geometry(LINESTRINGZM)

BTW, what's up with these magical numbers? I have no idea what these mean.

[rush42]

Exactly the first parameter is the type of the geometry and the second is the id to the spacial references system that is being used to represent the geometry.

[nene]

OK, so Postgres calls these things type modifiers, and they can be either numbers or identifiers.

The case of numbers is supported, as in the standard VARCHAR(100) or DECIMAL(5, 2).

The identifiers case I haven't encountered before. Needs to be implemented.

[nene]

Just out of curiosity, how does one know what the numbers mean when working with Postgis?

Like, is there some small set of numbers that users of Postgis know by heart? Like, if you look at:

CREATE TABLE roads (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64),
    geom geometry(LINESTRING, 3005)
  );

How does one know what the number 3005 means? Or maybe that question doesn't even make sense in the world of Postgis.

[rush42]

You can check out epsg.io. There you can search different coordinate systems and they give a brief summary.

[nene]

This is now fixed in 0.16.0