How to write stored procedure in plpgsql to connect to the sql server 2005?

[kallem]

Hi,

I just want to create a stored procedure/Function which should address the following features

1. Able to connect to the SQL Server 2005
2. fetch the data from tables
3. inserting into the postgresql database

Kindly suggest me the way forward or sample procedure

[rski]

Create foreign data wrapper and create foreign server

see here

http://wiki.postgresql.org/wiki/Foreign_data_wrappers

http://www.postgresql.org/docs/current/static/sql-createforeigndatawrapper.html

http://www.postgresql.org/docs/current/static/sql-createserver.html