postgres type column
--select * from information_schema.tables
-- from information_schema.tables
select 'if (table_name.equals("'||table_name||'")&&field.equals("'||column_name||'"))return "integer";',udt_name,'integer' from information_schema.columns where table_schema='hibernate'
and (udt_name in ('smallint','integer','bigint','decimal','numeric','real','double','serial','bigserial') or
(udt_name like '%int%'))
union
select 'if (table_name.equals("'||table_name||'")&&field.equals("'||column_name||'"))return "string";',udt_name,'string' from information_schema.columns where table_schema='hibernate'
and ((udt_name like '%character%') or (udt_name like '%varying%')or (udt_name like '%varchar%') or (udt_name ='text'))
union
select 'if (table_name.equals("'||table_name||'")&&field.equals("'||column_name||'"))return "date";',udt_name,'date' from information_schema.columns where table_schema='hibernate'
and (udt_name like '%time%')