[PostgreSQL] 함수 내에서 테이블(임시테이블) 컬럼명 추출하기

 

declare
    column_names TEXT;
begin    

    -- Get column names
    SELECT string_agg(column_name, ', ') INTO column_names
    FROM information_schema.columns
    WHERE table_name = '{{table_name}}';
    
    -- output
    RAISE NOTICE 'Columns: %', column_names;

end;