Hi, I'm getting an org.postgresql.jdbc.PgArray Object from Postgres (`text[]` column). How can I convert it to clojure vector?

you need to extend-protocol clojure.java.jdbc/IResultSetReadColumn

PgArray
  (result-set-read-column [v _ _]
    (vec (.getArray v)))

(extend-protocol  clojure.java.jdbc/IResultSetReadColumn
PgArray
  (result-set-read-column [v _ _]
    (vec (.getArray v))))

Dont forget to import (:import [org.postgresql.jdbc PgArray]))

many thanks!

more here http://clojure-doc.org/articles/ecosystem/java_jdbc/using_sql.html#protocol-extensions-for-transforming-values