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-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 com

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 t

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 > >> t

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 both

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 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 t

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