본문 바로가기

카테고리 없음

slickgrid data 넣을때 쿼리문으로 !! 정렬해서.!! 문자열 만들어서

select 
'{ name : "'|| b.description ||'", id: "'|| a.column_name || '", field: "'|| a.column_name || '", cssClass: "tal",  sortable: true, formatter:  Slick.Formatters.MoneyFormatter},'
from information_schema.columns a
left outer join pg_catalog.pg_description b
on b.objsubid = a.ordinal_position
inner join pg_class c
on b.objoid=c.oid 
and c.relname =a.table_name
where 1=1 
and a.table_schema='public'
and a.table_name='tb_optkwfid'