[PROJ] WKT2 in PostGIS

[Javier Jimenez Shaw]

Hi

In the new PROJ release 9.9.0 that will be released soon, the latest
version of EPSG is included.
As I already mentioned, all European realizations are included in the WKT2
of any CRS using the ETRS89 datum ensemble.
This is an example of EPSG:25830, with 4264 chars.
https://epsg.org/crs/wkt/id/25830
If you format it a bit nicely it goes up to 4874. And this is just an
example.


I realized today that in PostGIS the table containing the CRS has fields
limited to 2048 chars, in particular "srtext".
https://postgis.net/docs/using_postgis_dbmanagement.html#spatial_ref_sys_table

CREATE TABLE spatial_ref_sys (
  srid       INTEGER NOT NULL PRIMARY KEY,
  auth_name  VARCHAR(256),
  auth_srid  INTEGER,
  srtext     VARCHAR(2048),
  proj4text  VARCHAR(2048)
)

If I have to define a CRS with WKT2 because I need some features only
available in WKT2, it may not work in PostGIS. Am I right?

Anybody from PostGIS team here?

Thank you.
Javier.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/proj/attachments/20260909/fa20d13e/attachment.htm>