Go Postgresql Client: pgx custom json marshaller & unmarshaller

custom_json_pgx.go

package example

import (
	pgx "github.com/jackc/pgx/v5"
	"github.com/jackc/pgx/v5/pgtype"
	"github.com/jackc/pgx/v5/pgxpool"
)

func postgresCustomJSONUpgrade(conn *pgxpool.Pool) {
	conn.Config().AfterConnect = func(ctx context.Context, conn *pgx.Conn) error {
		conn.TypeMap().RegisterType(&pgtype.Type{
			Name: "json",
			OID:  pgtype.JSONOID,
			Codec: &pgtype.JSONCodec{
				Marshal:   json.Marshal,
				Unmarshal: json.Unmarshal,
			},
		})
		conn.TypeMap().RegisterType(&pgtype.Type{
			Name: "jsonb",
			OID:  pgtype.JSONBOID,
			Codec: &pgtype.JSONBCodec{
				Marshal:   json.Marshal,
				Unmarshal: json.Unmarshal,
			},
		})
		return nil
	}
}