Page 1 of 1

PostgreSQL Columns metadata

Posted: 19.02.2008, 10:22
by sandeep_c24
Hi Mark

I have been looking at GetColumns for Postgres and I just can't understand the following code

Code: Select all

        else if (PgType = 'numeric') or (PgType = 'decimal') then
        begin
          AttTypMod := GetInt(8) - 4;
          Result.UpdateInt(7, (AttTypMod shr 16) and $FFFF);
          Result.UpdateInt(9, AttTypMod and $FFFF);
          Result.UpdateInt(10, 10);
        end
Could you please get someone to look at this?

Do you think it is possible to use information_schema.columns to get the columns info?

Where could I send you the file that I have changed so far? I would like you or someone else to just check what I have been doing and point out any problems. I would prefer to send the zip of all the changed files.

Regards

Sandeep