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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly