pg_polyline

pig build pkg pg_polyline;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_polyline;		# install via package name, for the active PG version

pig install pg_polyline -v 18;   # install for PG 18
pig install pg_polyline -v 17;   # install for PG 17
pig install pg_polyline -v 16;   # install for PG 16
pig install pg_polyline -v 15;   # install for PG 15
pig install pg_polyline -v 14;   # install for PG 14

CREATE EXTENSION pg_polyline;

CREATE EXTENSION pg_polyline;

-- Encode an array of points to a polyline string
SELECT polyline_encode(
  ARRAY[point(-120.2, 38.5), point(-120.95, 40.7), point(-126.453, 43.252)], 6
);
--          polyline_encode
-- ----------------------------------
--  _izlhA~rlgdF_{geC~ywl@_kwzCn`{nI

-- Decode a polyline string back to points
SELECT polyline_decode('_ibE_seK_seK_seK', 6);
--       polyline_decode
-- ---------------------------
--  {"(0.2,0.1)","(0.4,0.3)"}