[postgis-users] INSERT geom Problem

[Markus Schaber]

Hi, Levert,

Levert Donovan wrote:

 > But this INSERT doesn't work :
> INSERT INTO "popplace"
> ("unique_key","name","the_geom") VALUES
> ('124','London','SRID=27582;0101000000000000A053984241000000C0789A3141');
> 
> Do you what is the format of
> 'SRID=27582;0101000000000000A053984241000000C0789A3141',
> how can I convert this to GeometryFromText() function
> ?
>
Try setsrid() function:

lwgeom=# select
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);
                      setsrid
----------------------------------------------------
 0101000020BE6B0000000000A053984241000000C0789A3141


Alternatively, produce the Hex-EWKB containing the SRID yourself.

HTH,
Schabi