public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron <[email protected]>
To: [email protected]
Subject: Re: bash or sql script to copy foreign table to locale table
Date: Thu, 19 May 2022 22:17:58 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <PAXP193MB15339A6E149E3CB509AD2827CAD09@PAXP193MB1533.EURP193.PROD.OUTLOOK.COM>
References: <MW4PR17MB4513FBC690156566FB0E5A17ABED9@MW4PR17MB4513.namprd17.prod.outlook.com>
<CAMa=N=NBvJv9vtCPz67a4jEP57ioVJwfTvscKXpA3JNidC-pKw@mail.gmail.com>
<MW4PR17MB4513397D5F05F0013DDDC150ABEC9@MW4PR17MB4513.namprd17.prod.outlook.com>
<PAXP193MB15339A6E149E3CB509AD2827CAD09@PAXP193MB1533.EURP193.PROD.OUTLOOK.COM>
Please do not hijack existing threads.
On 5/19/22 18:55, koff wrote:
> Hi all,
>
> I need little help please,
>
> I'v already foreign tables (from oracle_fdw) in my postgresql
> environment.
>
> I'm Just looking for script shell or sql ( easy way) to migrate
> this foreign tables to locale table .
>
> My script below has some issue
>
> thanks lot
>
> ------script migrate---
>
> #!/bin/bash
> export PGDATA=/pg01/pgdata/9.6/data
> export PGUSER="postgres"
> export PGPORT="5433"
> export PGPASSWORD="ttooe2"
>
> for tbl in `psql -qAt data_2020 -c "select foreign_table_name from
> information_schema.foreign_tables;"`;
> do
## note the added semicolon
> psql data_2020 -c "create table public.\"$tbl\" as select * from
> fdw_link.\"$tbl\";"
Here, either psql COPY the fdw_link.\"$tbl\" data OUT to a local file, and
then COPY IN to public.\"$tbl\" *OR* INSERT INTO public.\"$tbl\" SELECT *
FROM fdw_link.\"$tbl\";
> done
>
> ----end of script---
>
> the database is : data_2020
>
> foreign_table schema is : fdw_link
>
> and want to copy to public schema
>
>
>
>
>
>
--
Angular momentum makes the world go 'round.
view thread (8+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: bash or sql script to copy foreign table to locale table
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox