Re: Postgresql FDW - some difference between remote and target table structure

Hello Tom,

I appreciate to your response. It’s clear now to me.

Regards,
Gunce

On 5 Oct 2017 Thu at 16:55 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> =?UTF-8?Q?G=C3=BCnce_Kaya?= <guncekaya14(at)gmail(dot)com> writes:
> > Why there is some difference between FDW and target database? Is there
> > anyone who can explain it?
>
> Either the foreign table was created without that column to begin with,
> or the column was added to the remote table later and the foreign table
> wasn't updated to match. Foreign tables don't magically track what is
> on the remote server; they just have the set of columns you told the
> local server they should have.
>
> regards, tom lane
>
--
Gunce Kaya