Re: Adaptation of instnwnd.sql to Pgsql

David.Jacques@CCRS.NRCan.gc.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