Postgresql FDW - some difference between remote and target table structure

From: Günce Kaya <guncekaya14(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql FDW - some difference between remote and target table structure
Date: 2017-10-05 10:44:59
Message-ID: CAAV2-mXE87u0n86et4+3un4pR9C5Sh7APAANwmzRn=Gc=dCxSQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

We use FDW for some schemas and tables but I realised that a foreign
table's columns in FDW server and same table's columns in target database(I
said target db cause I'm not sure correct name for it) doesn't match. For
instance; in FDW server, I select that table and I can see XXX column,
however when I select same table and I can not see same column in target
database.

I check this table type in information_schema.tables and type of this table
is foreign table in .

Why there is some difference between FDW and target database? Is there
anyone who can explain it?

Regards,
Gunce Kaya

Linkedin <https://tr.linkedin.com/in/guncekaya> - Twitter
<https://twitter.com/gguncesi> - Blog
<http://www.guncekaya.blogspot.com.tr/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-10-05 13:55:35 Re: Postgresql FDW - some difference between remote and target table structure
Previous Message Laurenz Albe 2017-10-05 07:07:27 Re: streaming replication corruption Q's