Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread loref85
So, there's no way to do this? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046p5794581.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread Merlin Moncure
On Tue, Mar 4, 2014 at 6:48 AM, loref85 lore...@yahoo.com.ar wrote: So, there's no way to do this? You might want to give jdbc-fdw a try. not sure what's wrong with odbc -- looks like a driver mismatch issue. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread Adrian Klaver
On 03/04/2014 04:48 AM, loref85 wrote: So, there's no way to do this? In your original post you said you found a version of odbc_fdw that compiled for 9.2+, but hung on a select due to this error: ERROR: odbc_fdw::odbcGetTableSize: Could not retrieve table size Have you tried to contact

[GENERAL] Read tables of sql server with postgres

2014-02-21 Thread loref85
I'm trying to access sql server tables through postgres, I tried using this wrapper for databases with this ODBC driver http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window---Part-2.html , but the lastest version is compatible only with the