목록column명비교 (1)

그곰의 생활

[PostgreSQL] 코멘트 또는 데이터 타입(사이즈)가 다른 동일 컬럼명 목록 조회 쿼리

WITH tmp_column_dic AS ( SELECT c.column_name AS "column" , pgd.description AS "comment" , c.udt_name AS "type" , CASE WHEN c.character_maximum_length IS NOT NULL THEN c.character_maximum_length ELSE c.numeric_precision END AS "size" , c.table_name FROM pg_statio_all_tables st JOIN pg_description pgd ON pgd.objoid = st.relid JOIN information_schema.columns c ON pgd.objsubid = c.ordinal_position:..
Server-side/SQL 2022. 2. 9. 10:00
Prev 1 Next