Is is possible to query across servers in PostgreSQL? For example, by using an INSERT INTO query to insert table data from a table in one server to another? If so, would the query look roughly like the following:
INSERT INTO [destination table]
SELECT *
FROM [source server].[source schema].[source table]

?

I tried running this query, and received the following error “cross-database references are not implemented”