ccfontes

     column_name     | is_nullable | character_maximum_length | numeric_precision | numeric_scale | udt_name  | unique 
---------------------+-------------+--------------------------+-------------------+---------------+-----------+--------
 distance            | YES         |                          |                32 |             0 | int4      | 
 setting_preset_uuid | YES         |                          |                   |               | uuid      | 
 blocks              | YES         |                          |                   |               | _uuid     | 
 longitude_home      | YES         |                          |                 9 |             6 | numeric   | 
 latitude_home       | YES         |                          |                 9 |             6 | numeric   | 
 available_invites   | YES         |                          |                16 |             0 | int2      | 
 longitude_meeting   | YES         |                          |                 9 |             6 | numeri

ccfontes

SELECT c.column_name, c.is_nullable, c.character_maximum_length, c.numeric_precision, c.numeric_scale, c.udt_name, tc.constraint_type
FROM ((information_schema.columns as c
INNER
	JOIN information_schema.constraint_column_usage as ccu
		ON c.column_name = ccu.column_name)
INNER
	JOIN information_schema.table_constraints as tc
		ON tc.constraint_name = ccu.constraint_name)
WHERE table_name = 'users';

ccfontes

(defproject myapp "0.1.0-PROOF-OF-CONCEPT"
    :description ""
    :dependencies [[org.clojure/clojure "1.4.0"]
    			   [postgresql/postgresql "9.1-901.jdbc4"]
        		   [noir "1.3.0-beta10"]
        		   [crudite "0.1.1"]
        		   [org.clojure/java.jdbc "0.2.3"]
        		   [cljs-uuid "0.0.3"]
        		   [clj-time "0.4.4"]
        		   [noir-cljs "0.3.0"]