How to parse columns of type geometry or geography?

[kimmobrunfeldt]

Added this to document it for others

I have location column with type geography(Point, 4326);. When fetching rows , the column is returned as '0101000020E61000008013F823AFD03840A4A9A05C8C1F4E40' string?

How does one parse that?

[kimmobrunfeldt]

It can be parsed by adding a custom parser for slonik. For example:

import wkx from 'wkx'
const geographyParser = (value: string | null): any | null => {
  if (value === null) {
    return null
  }

  const wkbBuffer = Buffer.from(value, 'hex')
  const geometry = wkx.Geometry.parse(wkbBuffer)
  return geometry.toGeoJSON()
}


// later in your slonik `createPool` options:
  {
    name: 'geography',
    parse: geographyParser,
  },