SQL Server add a linked server to postgres database
PostgreSQL:


You  must provide a database name in the Data Source DSN.
Run Management Studio as Administrator
You must omit the DBName from the query:

SELECT * FROM OPENQUERY([LinkedServer], 'select * from schema."tablename"')