1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Export Progress OpenEdge column description as table comment in PostgreSQL

Discussão em 'StackOverflow' iniciado por fdantas, Abril 13, 2018.

  1. fdantas

    fdantas Administrator Moderador

    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

    [​IMG]

    Continue reading...

Compartilhe esta Página