select distinct table_name, concat('--',TABLE_COMMENT) from (

SELECT A.ordinal_position as COLUMN_ID

, '' OWNER

, A.table_name as TABLE_NAME

, B.obj_description as TABLE_COMMENT

, A.column_name as COLUMN_NAME

, C.comments as COLUMNS_COMMENTS

, A.data_type

||

CASE WHEN A.data_type != 'TIMESTAMP(6)'

THEN

(

CASE WHEN A.data_type = 'numeric'

THEN ' (' || A.numeric_precision || ') '

WHEN A.data_type = 'timestamp without time zone'

THEN NULL

ELSE ' (' || A.character_maximum_length || ') '

END

)

END as data_type

, A.is_nullable as NULLABLE

, '' as DATA_DEFAULT

, A.numeric_precision as DATA_PRECISION

, A.numeric_scale as DATA_SCALE

FROM information_schema.columns A

JOIN (

SELECT N.NSPNAME, C.RELNAME, OBJ_DESCRIPTION(C.OID) as obj_description

FROM PG_CATALOG.PG_CLASS C INNER JOIN PG_CATALOG.PG_NAMESPACE N ON C.RELNAMESPACE=N.OID

WHERE C.RELKIND = 'r'

AND NSPNAME = 'public'

--AND RELNAME = 'pts_cmmnty_master_mstr'

) B

ON A.table_name = B.relname

JOIN (

SELECT

PS.SCHEMANAME AS SCHEMA,

PS.RELNAME AS TABLE_NAME,

PA.ATTNAME AS COLUMN_NAME,

PD.DESCRIPTION AS comments

FROM PG_STAT_ALL_TABLES PS, PG_DESCRIPTION PD, PG_ATTRIBUTE PA

WHERE PD.OBJSUBID<>0

AND PS.RELID=PD.OBJOID

AND PD.OBJOID=PA.ATTRELID

AND PD.OBJSUBID=PA.ATTNUM

AND PS.SCHEMANAME= 'public'

--AND PS.RELNAME= 'pts_cmmnty_master_mstr'

ORDER BY PS.RELNAME, PD.OBJSUBID

) C

ON A.table_name = C.table_name

AND A.column_name = C.column_name

WHERE 1=1

-- AND A.OWNER IN ( 'KWM' )

AND A.table_name LIKE 'mw_%'

-- AND LENGTH (A.TABLE_NAME) = 9

-- 변경 -- PFCSOWR --AFCOWR

--AND A.column_name LIKE '%equipment_mng_num%'

-- AND C.COMMENTS LIKE '%담당자%'

--AND B.obj_description LIKE '%기관%' /* xpdlqmfaud */

-- AND A.COLUMN_ID = '1'

-- AND A.tablename = '테이블명'

ORDER BY A.table_name

, A.ordinal_position

) A

;

/**

* numberComma(n)

* 숫자에 콤마 추가함(12345 --> 12,345).

*/

function numberComma(n) {

//-- 정규식

var reg = /(^[+-]?\d+)(\d{3})/;

//-- 숫자를 문자열로 변환

n += '';

while (reg.test(n))

n = n.replace(reg, '$1' + ',' + '$2');

return n;

}

/*yyyyMMdd 형식의 날짜 문자열을 입력 받아 연(year)을 증감한다.*/

function addYear( dateStr, year ) {

dateStr = rmNotNumChar(dateStr);

return addYearMonthDay( dateStr, year, 0, 0 );

}

/*yyyyMMdd 형식의 날짜 문자열을 입력 받아 일(day)을 증감한다.*/

function addDay( dateStr, day ) {

dateStr = rmNotNumChar(dateStr);

return addYearMonthDay( dateStr, 0, 0, day );

}

function addYearMonthDay( source, year, month, day) {

if (isNaN(source) || source.length < 8) {

return "";

}

var yyyy = source.substr(0, 4);

var mm = parseInt(source.substr(4, 2));

var dd = source.substr(6, 2);

var dateStr = new Date(yyyy,(mm-1),dd);

var addDay;

if (year != 0) {

//console.log('@@@ year :: '+year);

addDay = new Date( dateStr.setFullYear( dateStr.getFullYear() + year ) );

}

if (month != 0) {

//console.log('@@@ month :: '+month);

addDay = new Date( dateStr.setMonth( dateStr.getMonth() + month ) );

}

if (day != 0) {

//console.log('@@@ day :: '+day);

addDay = new Date( dateStr.setDate( dateStr.getDate() + day ) );

}

//console.log('@@@ addDay :: '+getDateYMD(addDay));

return getDateYMD(addDay);

}

/* 입력된 date객체를 날짜형식으로 yyyymmdd */

function getDateYMD( source ) {

var now;

if( empty(source) ){

now = new Date();

}else{

now = new Date( source );

}

var year = now.getFullYear();

var month = ("0" + (1 + now.getMonth())).slice(-2);

var day = ("0" + now.getDate()).slice(-2);

return year + month + day;

}

/* 입력된 str객체를 날짜형식으로 YYYY-MM-DD */

function getDateFormatYMD( source ) {

source = rmNotNumChar(source);

if (isNaN(source) || source.length < 8) {

return "";

}

var yyyy = source.substr(0, 4);

var mm = source.substr(4, 2);

var dd = source.substr(6, 2);

var dateStr = new Date(yyyy,(mm-1),dd);

var year = dateStr.getFullYear();

var month = ("0" + (1 + dateStr.getMonth())).slice(-2);

var day = ("0" + dateStr.getDate()).slice(-2);

return year + "-" + month + "-" + day;

}

/* 해당달의 마지막 날짜 구하기 */

function getlastDay( source ) {

source = source.replace(/\D/ig, "");

if (isNaN(source) || source.length < 6) {

return "";

}

var year = source.substr(0, 4);

var month = source.substr(4, 2);

var newDate = new Date(year, month, 0);

var newYear = newDate.getFullYear();

var newMonth = newDate.getMonth()+1;

var newDay = newDate.getDate();

//console.log(newMonth);

if (newMonth.toString().length < 2) newMonth = "0" + newMonth;

if (newDay.toString().length < 2) newDay = "0" + newDay;

return newYear.toString() + newMonth.toString() + newDay.toString();

}