|
On 08/10/2012 12:35 PM, karthi keyan
wrote:
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 |
