Delete query from SQL Server 2008 to linked Postgres I want to delete some data from SQL Server 2008 in linked PostpresSQL.
I found this solution:

--DELETE data
DELETE FROM
OpenQuery('MSDASQL','SELECT  name  FROM sometable wHERE name LIKE ''test%'' ')


but how can I delete some data from SQL Server query in PostgresSQL?

Query from SQL Server 

select name from myMSSQL_table
DELETE data on linked server if user rights maped properly
run the same as normal SQL DELETE command, with full object names:

DELETE FROM [PGSQL].[demodata].[dbo].[tbl_Master]
SELECT * FROM [PGSQL].[demodata].[dbo].[tbl_Master]



  [Name of Linked Server].[database].[schema].[table]