Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Postgresql FDW - some difference between remote and target table structure - Mailing list pgsql-admin

From Günce Kaya
Subject [ADMIN] Postgresql FDW - some difference between remote and target table structure
Date
Msg-id CAAV2-mXE87u0n86et4+3un4pR9C5Sh7APAANwmzRn=Gc=dCxSQ@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [ADMIN] streaming replication corruption Q's
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure