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.
