I'm doing a db layout in Logic Works' Erwin. It can generate SQL
statements to create the database. Of course it doesn't include support
for PostgreSQL (yet) but I wondered which syntax was closest of the
supported ones.
These are supported:
DB2
SQL Server
Rdb
Oracle
SQLBase
Watcom/SQL Anywhere
Ingres
Sybase
AS/400
Informix
Progress
Teradata
Red Brick
InterBase
Also these client type "db"'s
Clipper
FoxPro
dBASE III
dBASE IV
Access
Paradox
I've tried Access (too few data types) and Oracle (Ugh. Everything in
capitals). Ingres seems to be close, but...?