foreign-data Archives

Rely on .pgpass in CREATE USER MAPPING

By adminPosted on January 5, 2023

Question : I am trying to create a script which creates a postgres-fdw connection between two postgres 9.4 databases. The […]

By adminPosted on December 23, 2022

Question : I have a few foreign data wrappers set up from my main PostgreSQL database to other databases. Is […]

By adminPosted on July 25, 2022

Question : PostgreSQL v9.6, postgres_fdw Foreign table CREATE FOREIGN TABLE user_info ( id bigint , info jsonb ) SERVER server_test_fdw […]

By adminPosted on July 1, 2022

Question : I been trying to get data from a SQL Server to use it on a PostgreSQL database. After […]

By adminPosted on June 12, 2022

Question : I have looked through the archives and I cant find any discussions around the following topic. I have […]

By adminPosted on May 9, 2022

Question : We have two servers (master, slave) and we want to use the FDW. The two databases to be […]

By adminPosted on February 19, 2022

Question : In 9.4b2, postgresql_fdw doesn’t know how to “push down” aggregate queries on remote tables, e.g. > explain verbose […]

By adminPosted on January 24, 2022

Question : I’ve got a foreign table from a distant csv host on a external webserver. I need to enhance […]

By adminPosted on December 17, 2021

Question : I have two databases. In each database I have an employee table which differ from each other in […]

By adminPosted on April 27, 2021

Question : I have an old Sql Server db with a ‘free entry’ field that is being accessed via a […]