I have some suggestions to improve the PostgreSQL support in TDM
allow the Not null constraints to be named (the way this is possible in Oracle, Postgres supports the same syntax)
Map TDM domains to real Postgres domains. Postgres supports domains directly, so TDM could generate the approriate CREATE DOMAIN statement instead of re-mapping the datatypes for the columns during DDL generation. Something like this:
CREATE DOMAIN d_lastname AS varchar(50) NOT NULL;
CREATE TABLE person (
id serial not null,
drop the addition of “with (oids=false)” completely in the generated SQL (if it’s unchecked). It only clutters the generated SQL and nowadays does not server any purpose as it’s the default anyway (as oids are deprecated).
Allow comments for sequences, views and domains (if generated). Currently sequences neither have “Notes” nor "Comments. And Views only have “Notes” which are not generated into SQL comments. I know this can be worked around using the “After Script”, but a “real” comment would be cleaner.
Add the option to specify “UNLOGGED” tables. This is a new feature in Postgres 9.1