Question : PostgreSQL v9.6, postgres_fdw Foreign table CREATE FOREIGN TABLE user_info ( id bigint , info jsonb ) SERVER server_test_fdw […]
Tag: foreign-data
Foreign Data Wrappers & Windows Authentication
Question : I been trying to get data from a SQL Server to use it on a PostgreSQL database. After […]
Postgres 12 Scalability using table Partitioning and Foreign Data Wrappers
Question : I have looked through the archives and I cant find any discussions around the following topic. I have […]
FDW, replication and CREATE SERVER – will it work?
Question : We have two servers (master, slave) and we want to use the FDW. The two databases to be […]
manual execution of specific remote query with postgresql_fdw
Question : In 9.4b2, postgresql_fdw doesn’t know how to “push down” aggregate queries on remote tables, e.g. > explain verbose […]
PostgreSQL : Refresh a materialized view base on a foreign table
Question : I’ve got a foreign table from a distant csv host on a external webserver. I need to enhance […]
naming a column differently then its original one in foreign data wrapper of PostgreSQL
Question : I have two databases. In each database I have an employee table which differ from each other in […]
Postgres special character rendering
Question : I have an old Sql Server db with a ‘free entry’ field that is being accessed via a […]
user mapping hide password
Question : I would like to perform queries over different postgresql11-databases. Therefore I created a data wrapper and a user […]