[Stackoverflow] [Progress OpenEdge ABL] Export Progress OpenEdge column description as table comment in PostgreSQL

[KuKeC]

I have managed to export database structure from Progress Open Edge to PostgreSQL but without any column comments. Since lots of tools for migrating are limited with functionality I was thinking about making SQL code myself. So now I'm thinking about looping thru all tables and columns in my database "data" and generating SQL code like below

COMMENT ON COLUMN public.table_name.table_column IS 'Value from PROGRESS';


Since I'm not familiar with any system tables in Progress I'm asking for guidance for looping thru all tables and columns in my database "data" and getting values from picture below



Continue reading...