David(dot)Jacques(at)CCRS(dot)NRCan(dot)gc(dot)ca wrote:
> Listers...
>
> I am new to PostGreSQL and I am trying to adapt the
> instnwnd.sql stored procedure from SQL Server to create the
> ubiquitous NorthWind database structure on my server. However
> the ability to name your indexes seems to be non existent.
This is not true. During the index creation you can specify
the name, take a look at the documentation.
> As is the ability to create indexes of the same name on different tables.
About this you're right, index name are DB wide...
Regards
Gaetano Mendola