Genealogicaley, Ingres would indeed be closest to pgsql (both are direct
descendants of University Ingres).
Probably a nicer thing would be for ERwin to have SQL-92 dialect, but
since nobody other than postgres even tried to comply to it, ERWin doesn't
support it ;)
On Thu, 30 Nov 2000, Ed Loehr wrote:
> I'm using ERwin to reverse engineer an ER diagram from PostgreSQL SQL
> scripts (via pg_dump). ERwin does not officially support PostgreSQL's
> flavor of SQL, though having it read PostgreSQL scripts as Ingres scripts
> seems to work ok.
>
> Is there another well-known RDBMS vendor (Informix?) whose dialect and
> SQL idiosyncrasies (sp?) are closer to PostgreSQL's SQL than Ingres?
> ERwin supports most of the big RDBMS names (Pg is the only one I noticed
> missing), and I don't know much about the various dialect differences.
>
> Regards,
> Ed Loehr
>
>
