Import data from one instance another

Started by Rama Krishnanabout 5 years ago2 messagesgeneral
Jump to latest
#1Rama Krishnan
raghuldrag@gmail.com

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

#2Wim Bertels
wim.bertels@ucll.be
In reply to: Rama Krishnan (#1)
Re: Import data from one instance another

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