T-SQL Openquery - error due to space in the table name

Question

I have the below query that is trying to pull data from Sage 50 pervasive 13 database into SQL server using a link server. I've been able to pull all data from all tables into SQL Server except for this one table because it has a space in the table name.

I've not been successful with anything I've changed it to. Can anyone help me get this query working?

select * 
from openquery(ARKSAGE,'select * from NEPHROPATHOLOGYASSO1.Budget Details')

When I change the above query to this:

select * 
from openquery(ARKSAGE,'select * from NEPHROPATHOLOGYASSO1.[Budget Details]') 

I get this error message:

OLE DB provider "MSDASQL" for linked server "ARKSAGE" returned message "[PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine]Syntax Error: select * from NEPHROPATHOLOGYASSO1.<< ??? >>[Budget Details]".

Msg 7321, Level 16, State 2, Line 61
An error occurred while preparing the query "select * from NEPHROPATHOLOGYASSO1.[Budget Details]" for execution against OLE DB provider "MSDASQL" for linked server "ARKSAGE".

Answer 1

The PSQL in the error message tells me the linked server is probably running Postgresql, rather than SQL Server. Postgresql marks object names with double quotes instead of brackets. Therefore you should try this:

select * 
from openquery(ARKSAGE,'select * from NEPHROPATHOLOGYASSO1."Budget Details"')

Additionally, I'm not sure what the << ??? >> text is for, but it looks a little like it's complaining about an odd unicode character in there somewhere. So look out for invisible whitespace. Or maybe it's just part of how the error message is formatted in the context of a linked Postgresql server.