Bob McConnell <rmcconne@lightlink.com> writes:
> But I have only found articles on how to convert from MySQL to Postgres
> and a few on how to convert from SQL Server to MySQL. So how do I
> translate this without leaving the bad taste of MySQL in my mouth? Or is
> there a similar recommended practice for Postgres?
I believe the main thing you need to know is that the brackets are
a nonstandard spelling for quoted identifiers. That is
[MajorReleaseNumber] converts to "MajorReleaseNumber".
(You might be better off translating to MajorReleaseNumber without the
quotes, which will really mean majorreleasenumber. Depends whether you
want to double-quote every use of the name in your applications.)
The IDENTITY business probably equates to SERIAL, and there are some
other nonstandard things here like the CLUSTERED adjective.
regards, tom lane