Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-10 Thread Merlin Moncure
On Jan 4, 2008 11:51 AM, Afewtips.com [EMAIL PROTECTED] wrote: I do read mentions about dblink connections, but how to install it looks unclear and complicated. small clarification here. dblink is for connecting two postgresql databases together. It is, IMO, neither unclear nor

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-10 Thread Joshua D. Drake
Merlin Moncure wrote: On Jan 4, 2008 11:51 AM, Afewtips.com [EMAIL PROTECTED] wrote: I do read mentions about dblink connections, but how to install it looks unclear and complicated. small clarification here. dblink is for connecting two postgresql databases together. It is, IMO, neither

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-09 Thread Joshua D. Drake
Ow Mun Heng wrote: On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote: Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and

[GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Afewtips.com
Hi, I am new to this product and don't quite know what can and cannot be done. I need to submit queries to a SQL Server database and create a table in Postgresql with the results from SQL Server. Normally I would do this with an ODBC driver into SQL Server, but I don't see any references to

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Afewtips.com
On Jan 4, 10:08 am, Afewtips.com [EMAIL PROTECTED] wrote: Hi, I am new to this product and don't quite know what can and cannot be done. I need to submit queries to a SQL Server database and create a table in Postgresql with the results from SQL Server. Normally I would do this with an

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Sim Zacks
Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then putting the data into your postgresql. Sim Afewtips.com wrote: On Jan 4, 10:08 am, Afewtips.com [EMAIL PROTECTED] wrote: Hi, I am new to this

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Ow Mun Heng
On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then putting the data into your postgresql. I use perl DBI to connect to both PG and MSSQL.

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Joshua D. Drake
Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then putting the data into your postgresql. I use perl DBI to connect to

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

2008-01-08 Thread Ow Mun Heng
On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote: Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then