foreign-data-wrapper Questions
3
Solved
The idea is that I have local database named northwind, and with postgres_fdw I want to connect with another database named test on localhost (remote connection simulation, for situations like when...
Culdesac asked 27/4, 2015 at 16:6
5
Solved
Using Postgres 9.6 with postgres_fdw extension, there any means to keep the tables present within the local schema in-sync with the tables on the remote database? I often need to add new tables to ...
Agronomy asked 29/8, 2017 at 12:16
2
Solved
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...
Dunt asked 26/2, 2018 at 11:51
3
Solved
I'm creating a foreign table (foo_table) in database_a. foo_table lives in database_b. foo_table has an enum (bar_type) as one of its columns. Because this enum is in database_b, the creation of th...
Authoritarian asked 19/5, 2015 at 17:55
1
Solved
I have two databases that I want to be able to transfer data between, so I want to import a large schema from one database to the other, where there is allot of enums. So I ran into the problem des...
Spirituality asked 15/10, 2021 at 11:33
1
Solved
Suppose I want to query a big table with a few WHERE filters. I am using Postgres 11 and a foreign table; foreign data wrapper (FDW) is clickhouse_fdw. But I am also interested in a general solutio...
Apochromatic asked 29/4, 2020 at 1:9
1
I have a foreign table, for example:
CREATE FOREIGN TABLE film (
id varchar(40) NOT NULL,
title varchar(40) NOT NULL,
did integer NOT NULL,
date_prod date,
kind varchar(10),
len interval hou...
Pantheism asked 22/5, 2016 at 23:37
1
Solved
I created a foreign data wrapper table named t_user into mySchema.
IMPORT FOREIGN SCHEMA public LIMIT TO (t_user)
FROM SERVER myServer INTO mySchema;
The myServer side t_user added some column,...
Suggestibility asked 12/12, 2018 at 6:4
0
I have a table in an MS Access db that I want to export to a PostgreSQL database. Every 2 or so months, I want to move all records from the Access table to a table in Postgres.
Right now, I am us...
Surcease asked 5/3, 2018 at 17:59
2
Solved
Could somebody help me understand how I would go about setting up postgresql's mysql_fdw? I'm looking at https://github.com/EnterpriseDB/mysql_fdw, and I not sure what the first step is.
Petition asked 10/7, 2014 at 17:43
1
Solved
This question is related to an earlier one: Why is selecting from stored procedure not supported in relational databases?
On SQL Server you cannot perform a join to (or a select from) a stored pro...
Lacagnia asked 24/11, 2015 at 14:14
1
Solved
I've got a foreign table (using postgresql_fdw foreign data wrapper) and I need to find maximum ID to copy all records. When I run SELECT MAX(id) FROM foreign_table it doesn't seem to be using inde...
Dressy asked 23/11, 2015 at 13:37
2
Solved
I'm very excited by several of the more recently-added Postgres features, such as foreign data wrappers. I'm not aware of any other RDBMS having this feature, but before I try to make the case to m...
Heerlen asked 1/5, 2014 at 16:9
1
© 2022 - 2024 — McMap. All rights reserved.