[PROJ] WKT2 in PostGIS

[Javier Jimenez Shaw]

PROJCS is WKT1. In WKT2 it would be PROJCRS (note the R)

As far as I understood, PostGIS does now support WKT2 (but maybe I am wrong)

On Wed, 9 Sept 2026 at 16:09, Greg Troxel via PROJ <proj at lists.osgeo.org>
wrote:

> Javier Jimenez Shaw via PROJ <proj at lists.osgeo.org> writes:
>
> > 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)
> > )
>
> I have locally installed 9.9.0RC1 (and proj-data 1.25RC1, surely
> unrelated), and built postgis.
>
> Looking at spatial_ref_sys.sql, I see
>
> --
>
>
>
> -- EPSG 25830 : ETRS89 / UTM zone 30N
>
>
>
> --
>
>
>
> (25830, 'EPSG', 25830, 'PROJCS["ETRS89 / UTM zone
> 30N",GEOGCS["ETRS89",DATUM["European_Terrestrial_Reference_System_1989",SPHEROID["GRS
> 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6258"]]\
>
> ,PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4258"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-3],PARA\
> METER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","25830"]]',
> '+proj=utm +zone=30 +ellps=GRS8\
> 0 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs '),
>
> which appears not to include the ensemble members.  I don't see a
> postgis NEWS about a new EPSG version since 2.5.0, but obviously that
> isn't how it is.
> _______________________________________________
> PROJ mailing list
> PROJ at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/proj
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/proj/attachments/20260909/5db7a975/attachment.htm>