oarj3=> select column_name,data_type from information_schema.columns where table_name like 'urls';
   column_name   |     data_type     
-----------------+-------------------
 date_checked    | date
 http_code       | integer
 base_uri        | text
 host_alive      | boolean
 last_check_good | boolean
 count_fails     | integer
 count_success   | integer
 pri             | boolean
 url             | text
 table_id        | integer
 tbl             | character varying
 id              | integer
(12 rows)