Re: Import data from one instance another

From: Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Import data from one instance another
Date: 2021-03-09 09:20:05
Message-ID: 3ed5e6f92b078a6c7e91d0afc0a46167325cc48f.camel@ucll.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Rama,

not quiet sure what the question is,
you can choose the name of the foreign table
https://www.postgresql.org/docs/current/postgres-fdw.html

Rama Krishnan schreef op di 09-03-2021 om 14:47 [+0530]:
> Hi Team,
>
> I have two instances called A and B, in A instances I have one table
> name called sports I want to import data from A into B instances I
> found foreign data wrapper is the best solution when the table is
> huge here I have doubt is it foreign data wrapper and foreign tables
> are same?
>
>
> Thanks
>
> Rama Krishnan
--
mvg,
Wim Bertels
--
https://coronalert.be

Lector
UC Leuven-Limburg
--
"... an experienced, industrious, ambitious, and often quite often
picturesque liar."
-- Mark Twain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wim Bertels 2021-03-09 09:56:26 curious cost vs execution time (local test)
Previous Message Rama Krishnan 2021-03-09 09:17:02 Import data from one instance another