PostgreSQL support in PowerDesigner 16.6

[Former Member]

We have created a conceptual data model and generated a physical data model. When generating the physical datamodel we chose PostgreSQL 9.x. It seems that the mapping of datatypes from CDM to PDM is lacking in regards to PostgreSQL.

PostgreSQL has a UUID data type. This datatype is not possible to choose in Powerdesigner. Not even when choosing the data type directly in the PDM. Does anyone know if it is possible to obtain an updated pgsql9.xdb definition file that can then be imported in Powerdesigner?

[skymaster337]

I would be very interested in seeing the answer for this too.

[Ondrej_Divis]

Hi,

you are right, UUID is missing. The only thing (besides PD customization) you can do, is obtain newest PD version (currently PD 16.7 SP06 PL01) and check, whether UUID is already there. I kinda doubt it, because in my 16.7 SP03 it is still not there. But, you can add missing datatypes to your definition file using your own customization. Check items in folder Script\DataType in your definition file.

In PDM, you can easily define your datatype in your definition file, it is 2 minutes job. You can even influence, how the datatypes are being translated from CDM datatypes to your PDM datatypes, again, it is quite simple. But, you CANNOT DEFINE new datatype for your CDM models. This kind of setting is unfortunately not available. So what you can do? You can choose one of the following options:

• You can find one already existing datatype in CDM and according to translation lists in your definition file (Script\DataType) you can adjust it to generate UUID datatype in your PDM model. The biggest disadvantage here that in CDM it still could not be named UUID, so you will have to remember which datatype serves for your UUID columns.
• In CDM you will write UUID datatype directly/manually into the datatype field of an entity attribute and it will remain UUID datatype even after being generated to PDM.

Second way is IMHO much better (however it is not the best solution you could be hoping for)

Let me know, if you need more help on this.

Ondrej Divis