pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Adaptation of instnwnd.sql to Pgsql 3+ messages / 3 participants [nested] [flat]
* Adaptation of instnwnd.sql to Pgsql @ 2004-10-06 14:41 David.Jacques@CCRS.NRCan.gc.ca 0 siblings, 1 reply; 3+ messages in thread From: David.Jacques@CCRS.NRCan.gc.ca @ 2004-10-06 14:41 UTC (permalink / raw) To: pgsql-admin 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. As is the ability to create indexes of the same name on different tables. Does anyone out there have an adapted Pgsql version of this script ? It would be invaluable to me to get quickly up to speed on this version of the SQL standard by comparing what I know from TSQL to what the equivalent command syntax is in pgsql. regards David David A. Jacques Spatial Database Developer Natural Resources and Hazards Section Applications Division Canada Centre for Remote Sensing 588 Booth Street, Room 317 Ottawa ,Ontario K1A 0Y7 Tel: (613) 947-1306 Fax: (613) 947-1408 E-Mail: David.Jacques@CCRS.NRCan.gc.ca The views and ideas expressed in this communication are hereby deemed to be my own and in no way can be construed as endorsed by the CCRS or the Government of Canada. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Adaptation of instnwnd.sql to Pgsql @ 2004-10-06 23:01 Gaetano Mendola <mendola@bigfoot.com> parent: David.Jacques@CCRS.NRCan.gc.ca 0 siblings, 1 reply; 3+ messages in thread From: Gaetano Mendola @ 2004-10-06 23:01 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Adaptation of instnwnd.sql to Pgsql @ 2004-10-06 23:50 Tom Lane <tgl@sss.pgh.pa.us> parent: Gaetano Mendola <mendola@bigfoot.com> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2004-10-06 23:50 UTC (permalink / raw) To: Gaetano Mendola <mendola@bigfoot.com>; +Cc: pgsql-admin Gaetano Mendola <mendola@bigfoot.com> writes: > David.Jacques@CCRS.NRCan.gc.ca wrote: >> As is the ability to create indexes of the same name on different tables. > About this you're right, index name are DB wide... Only schema-wide, but that probably doesn't help David any... regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-10-06 23:50 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-10-06 14:41 Adaptation of instnwnd.sql to Pgsql David.Jacques@CCRS.NRCan.gc.ca 2004-10-06 23:01 ` Gaetano Mendola <mendola@bigfoot.com> 2004-10-06 23:50 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox