Question : I am trying to create a script which creates a postgres-fdw connection between two postgres 9.4 databases. The […]
Tag: foreign-data
Listing active PostgreSQL foreign data wrappers
Question : I have a few foreign data wrappers set up from my main PostgreSQL database to other databases. Is […]
ORDER BY too slow in Foreign Table using postgres_fdw
Question : PostgreSQL v9.6, postgres_fdw Foreign table CREATE FOREIGN TABLE user_info ( id bigint , info jsonb ) SERVER server_test_fdw […]
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 […]
- 1
- 2