postgresql.clj

(require '[clojure.java.jdbc :as sql])

(def db
  "postgresql://postgres:postgres@localhost:5432/shouter")

(sql/with-connection db
 (try (sql/drop-table :testing) (catch Exception _)))

(sql/with-connection db
 (sql/create-table :testing [:data :text]))

(sql/with-connection db
 (sql/insert-rows
   :testing
   ["Hello, world!"]
   ["Hello, PostgreSQL!"]))

(sql/with-connection db
  (sql/with-query-results results
    ["select * from testing"]
    (into [] results)))

Apache Derby 版は https://gist.github.com/4484275

project.clj の [postgresql "9.1-901.jdbc4"] も忘れずに。