Re: PostgreSQL - linked with MSSQL - Mailing list pgsql-odbc

From Richard Huxton
Subject Re: PostgreSQL - linked with MSSQL
Date
Msg-id 42721147.5060001@archonet.com
Whole thread Raw
In response to Re: PostgreSQL - linked with MSSQL  (pk2@o2.pl)
List pgsql-odbc
pk2@o2.pl wrote:
> Generally I would like to have the same possibility to make an:
> INSERT INTO [Postgres_server].mydatabase.user.mytable
> (id, data1, data2, data3)
> SELECT
> id, data1, data2, data3
> FROM [remote_mssql].remotedatabase.dbo.table2

The quick solution (and the one I always use) is to setup ODBC for
postgresql, then create an MS-Access database that links to both. Add a
bunch of queries/vba and you're done.

--
   Richard Huxton
   Archonet Ltd

pgsql-odbc by date:

Previous
From: pk2@o2.pl
Date:
Subject: Re: PostgreSQL - linked with MSSQL
Next
From: "Merlin Moncure"
Date:
Subject: Re: PostgreSQL - linked with MSSQL