Postgresql citext support with Clojure JDBC + Postgres

gistfile1.clj

;; citext with JDBC
;; Using the technique at: http://hiim.tv/clojure/2014/05/15/clojure-postgres-json/

(import 'org.postgresql.util.PGobject)


(extend-protocol j/IResultSetReadColumn
  PGobject
  (result-set-read-column [pgobj metadata idx]
    (let [type  (.getType pgobj)
          value (.getValue pgobj)]
      (case type
        "citext" (.toString value)
        :else value))))

;; For queries, you need to prevent jdbc from coercing to string
;; add the following to the jdbc uri

;; ?stringtype=unspecified

;; Source: https://www.postgresql.org/message-id/CAJFs0QC_nn5WxhrgMuXsK%3DWCc5JHvMmGk%[email protected]

Thank you for gisting this!

The suffix: ?stringtype=unspecified was a timesaver.