unknown PostgreSQL type: json

[farwydi]

PostgreSQL vers 10

Shema

CREATE TABLE meta_point_params
(
    id         SERIAL       NOT NULL
        CONSTRAINT meta_point_params_pk
            PRIMARY KEY,
    point_id   INTEGER      NOT NULL
        CONSTRAINT meta_point_params_points_id_fk
            REFERENCES points
            ON DELETE CASCADE,
    param_name VARCHAR(208) NOT NULL,
    value      JSON         NOT NULL
);

Query:

-- name: PreFetchPointParamsByPointIds :many
SELECT *
FROM meta_point_params mpp
         INNER JOIN points p ON mpp.point_id = p.id
WHERE p.id = $1;

[farwydi]

Should be json.RawMessage or []byte

[farwydi]

Simple solution in the config

overrides:
  - go_type: "encoding/json.RawMessage"
    db_type: "json"