On 08/10/2012 12:35 PM, karthi keyan wrote:
Actually my need is import data from PostgreSQL , and the same process into sql server.
I'm guessing you didn't see what I wrote in reply to your message, where I said:
You haven't really shown enough information. In particular, where does this 'Postgre' variable/table/whatever come from? What is it?
You should look at the PostgreSQL server logs to see if PostgreSQL is sending an error when you attempt the connection and if so, what it is. Consider also setting log_statement = 'all' in postgresql.conf so you can see exactly what queries this "openquery" tool runs against PostgreSQL.
By the way, the easiest way to do this sort of thing is usually to
COPY tablename TO '/some/file.csv' CSV
from PostgreSQL, then load that file into MS SQL server. That's trivial to script with vbscript or whatever you prefer, using psql to get the data out of PostgreSQL.
--
Craig Ringer