python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - foreign-data-wrapper

Create trigger in MS SQL Server database to insert/update into another Postgres database

We are changing MS SQL Server to Postgres in our application. The application uses Blue-Green deployment, which is why there will be a period of time when the old version will still work with MS SQL ...
test-img

FireShock

sql-server

postgresql

triggers

linked-server

foreign-data-wrapper

Votes: 0

Answers: 1

Latest Answer

You can try this tutorial and see if it works for you https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration-part-2/
test-img

Nat

Use foreign data wrapper for forwarding

The following architecture: Server A has access to Server B, Server B has access to Server C, but Server A has no direct access to Server C. I can create a foreign server on Server B like this: CREATE...
test-img

Lokomotywa

postgresql

proxy

foreign-data-wrapper

Votes: 0

Answers: 1

Latest Answer

Yes, that is possible. Define a foreign table on B that accesses a table on C, and define a foreign table on A that accesses the foreign table on B. It is straightforward.
test-img

Laurenz Albe

Slow performance of Postgresql script with foreign server

As a former SQL Server developer, I am curious, why that kind of script can be extremely slow in Postgresql? I have some tables on local database in public schema, and I configured a foreign server wi...
test-img

Gerard Jaryczewski

postgresql

performance

foreign-data-wrapper

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs