I would like to use postgres_fdw and house a FOREIGN TABLE in my database. Is it possible to define a trigger on the local server for this FOREIGN TABLE that recognizes an INSERT event on the remot...

My problem is that I am using PostgreSQL database and want to import a table named vfm from other database, say B. But there's a table with the same name table in my current database (A). I'm getti...

can be used postgres_fdw to connect via ssh tunnel? The database is accessible only from the DB server, andI need to join from another remote server. The DB server log in with SSH keys. If it's ...

I have two Postgres 9.3.5 instances in RDS, both in one security group that allows all inbound traffic from within the security group and all outbound traffic. I'm trying to set up one database to ...

Is it possible to create a foreign table, using Postgres Foreign Data Wrapper, that points to a view instead of a table?

suppose I have a query like select * from remote_table join local_table using(common_key) where remote_table is a FOREIGN TABLE with postgres_fdw and local_table is a regular table. local_tab...

I'm connected to schema apm. Trying to execute a function and getting below error: ERROR: user mapping not found for "postgres" Database connection info says: apm on postgres@PostgreSQL ...

I have a use case to distribute data across many databases on many servers, all in postgres tables. From any given server/db, I may need to query another server/db. The queries are quite basic, sta...