I have created three views on my company's postgres server that I would like to query using the OLEDB adapter from SQL Server via linked server. I tried using an OPENQUERY statement to reference the view, but I get an undefined table message. (see below)
FROM OPENQUERY (BSI,'SELECT * FROM public."BSI_AccountContainer"')
Can someone help with my syntax to see if that is an issue?