PGSQL vs. SQL Server questions

Поиск
Список
Период
Сортировка
От Lee Matthews
Тема PGSQL vs. SQL Server questions
Дата
Msg-id 51F7D18A1EFED4118BF300B0D02DE9B1BC07B4@MELBEXCHANGE1
обсуждение исходный текст
Ответы Re: PGSQL vs. SQL Server questions  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: PGSQL vs. SQL Server questions  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
I am interested in PGSQL as an alternative to MS SQL Server but am not aware of its capabilities. I have already written a number of SQL queries to create tables, views and insert data into a database in SQL Server. Can someone please advise me of the following, or alternatively point me to a relevant source of info :
 
Is there a tool like SQL Query Analyser that will allow me to run my existing SQL statements a PGSQL database?
Can you setup database views in PGSQL?
Are the main SQL Server datatypes matched in PGSQL (ie. varchar, decimal, int, datetime)?
Is an OBDC compliant driver for PGSQL that will enable my COM objects to work against both PGSQL and SQL Server by merely varying the connection string?
 
Thanks for any assistance you can offer.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Heath Tanner
Дата:
Сообщение: Re: Question regarding keyword checkboxes in database
Следующее
От: Nabil Sayegh
Дата:
Сообщение: Re: PGSQL vs. SQL Server questions