Message-ID: 
 <PAXP193MB15339A6E149E3CB509AD2827CAD09@PAXP193MB1533.EURP193.PROD.OUTLOOK.COM>
Date: Fri, 20 May 2022 01:55:06 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
 Thunderbird/91.3.0
Subject: bash or sql script to copy foreign table to locale table
Content-Language: fr
To: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@lists.postgresql.org
References: 
 <MW4PR17MB4513FBC690156566FB0E5A17ABED9@MW4PR17MB4513.namprd17.prod.outlook.com>
 <CAMa=N=NBvJv9vtCPz67a4jEP57ioVJwfTvscKXpA3JNidC-pKw@mail.gmail.com>
 <MW4PR17MB4513397D5F05F0013DDDC150ABEC9@MW4PR17MB4513.namprd17.prod.outlook.com>
From: koff <koff10@hotmail.com>
In-Reply-To: 
 <MW4PR17MB4513397D5F05F0013DDDC150ABEC9@MW4PR17MB4513.namprd17.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-Office365-Filtering-Correlation-Id: a596cd62-31ec-4021-c17d-08da39f30061
X-MS-TrafficTypeDiagnostic: AM0P193MB0644:EE_
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info: 
	v6TvnxK4i/CMXmiQkjBGqbkjg3pygrbsc+vnrMQWfuP4tY4Npfn5yBK9XW3nhWHb+7kG1CF8KYrRYge581lW7ShkCcwLL8AmLpjMOOpgehsieOsnfVS2vUKPxp6TjUHVEhIXRuQPNViizLby2Oi4e5BJG5UCRiA5gt0U4pjwN5ITVyv9HoOUnTO855ttPofC8j/Y9XHRj5QdHdAlOAjyWY6MN4mQ05zc0KyBYLTNWd+I0afD1N/mneyaz59w61ljx8tZ8RKHXRtPPR7x0TYigF26gelSLADM5OQjjQwUXVox1tLuCfkUC3MOI4skBkV2eWiI+QWUSue2o72H+1YaL7bLySdwjKXWgf5ZM7NQjCwaubUyyOhAeY9NBR3z41mhbU28LHK2ElsFYxSWqxc9FZbNflBYex+lIxrMWmdzVs/yQqp8NwHQt7Y/UgXbqAuMluFJqcRo38zmp178LBhRtXM7XqBP6KVQHDBLafnts0T4rimS18sVdocfxuWD4tQY1huYuRWNPjlE7k5xGAXSwPpPNNFYR+zYv60rDFyPiPS4yXaExaDprlZhQYsfLxymYloUMVuL8rQN26TxBpwc9A==
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?utf-8?B?VU42bjZaK2xwZkpyMHRhQmN3UjNXemRhWG5QanY5WGxFR2t4RUd5dW9TSFRV?=
 =?utf-8?B?bWRtOTBPOFRHeDM3bnpWK1M2Q3Z2VjNyRFg5R1lwV1V0NDdBVmJFRlVtbGhN?=
 =?utf-8?B?RmxFVHE1K1RzdjdGZVRyM0NGVFRvZ056YUNLakxza1I5WnhtTUlsb1NCb3hJ?=
 =?utf-8?B?UjRyaWdwLzJKOHFNbWNUNEpsTHU3VmkyL0FCeFlSZ1huS3RZSGovWUw2T0RZ?=
 =?utf-8?B?SWZXeE9XQWFHMEhSejNVRmo5amRidEZlRVpqdmVITEZaK0dmZmd3TzBhdzY0?=
 =?utf-8?B?ZktTbzcvTFVCSmhyMWhwNVVlUEtPSTJqTk8wR0pFZDFtM3o4Y2o1SStOTU5q?=
 =?utf-8?B?WSttUy9yaUdGQ2tCMlRiOVAzTWhiSnZPUEtvSVhRSnpLdk13d0orUmtFd2RV?=
 =?utf-8?B?M1ZxZWpyeGFjMnc2REw0UG8zWURqcWErQ1JpWGhwZWtCSUIyWDYyMnJreVRE?=
 =?utf-8?B?SnVsdVZRZURSTHE4N2c4bEVocDg3Tnl5MEMvTEg3UTlCL1lrRUx3RUFoNjFM?=
 =?utf-8?B?UzZzcEhYUkV0Z1hnVDBxamtTZG5CSEdZVmlyTGZaRkFKekUxZ1dJUFVENEwr?=
 =?utf-8?B?endQYmpmNy9NdC9Mem14NXVWZTArSzJHcjFPdTY4a3lVWlh4UFhYc2Z1ajdL?=
 =?utf-8?B?TkU1RUxlcitlY1ZDYndxS0dPajR0TUZNYkZ0M3cxbHB6YS9NZTVvb2xlbE15?=
 =?utf-8?B?d3BZSm9zS1RJUlY4bTNSVVJsVkQ4VFFkdEdhOWFJejY2YkU1ZEI2aHQwOWdr?=
 =?utf-8?B?emUwQ1RmeE5ubUc0QituTmIrZ1R0MGZzY25oNC9UQVFMU2s3RWE3ZzF5Wm8w?=
 =?utf-8?B?aHpyN01DbDdIbVkxbTJUNm16Tnp3bHFXTlJtS08yNTBOaVN1UmNVbkFMUHd6?=
 =?utf-8?B?NlRCTXMreXMvN1MxcHQrTlhWMkpBempuTWxVVmN4MGE5ZUdMQm56ellIOG04?=
 =?utf-8?B?RUI0NmU3T3JMSEcwa3ZCYnd2K0lNcUU5TG9pOWpiVUNIeXdiVXlEWWkrWVVp?=
 =?utf-8?B?cmgwODZUV0Z1K1ZlS2FyNFZrdEdKQmtlMm1uNkwvdTNIUHN6OHVJME5Sbnky?=
 =?utf-8?B?eXRORmdoT0NqUTgzd2pmZGF4R29MdTN0OG9OeDRqWE12L2o2ZXp5bkl6VzNz?=
 =?utf-8?B?eWdtMXpKZnlnYjBUck1MTXlrcFZZdlBVekVCNkNTaWdyMTVWM3l2enNPUUt2?=
 =?utf-8?B?WkF4ek5TaW1NWGZ1UlpRSWdERUwzNFNzbFVRenEvd2pqRzBmNmFaaDdkRksv?=
 =?utf-8?B?MnhLcktNVFkyVk1mWnZoMEZmR0JPbXB2UElwVWJOUndybi9PVVc5VUJjWUV0?=
 =?utf-8?B?b3o4ZmxCOElhYXA4N3RDNnBuSzNheVJIU3BhRHozSkdUMkxpazd3T0ZZR2hn?=
 =?utf-8?B?WitjRXJFdWtNWE5rRktscHMxZjVrWFoxeXJxZ2JVK2FHUUJEMytZNUM4SzFj?=
 =?utf-8?B?cE9ia1VSWVlwL0FCWkJkS1pLc055UHhEaE96OVMyb3VHZU9lcWpNWjA1Y0pU?=
 =?utf-8?B?NCthRGwrT0NlbGN2MjIwZWlQcFlEQ051NUo5VGowUWs0Y0pseGFVaDR4ZSs4?=
 =?utf-8?B?NTErbUk1QkFIV1Q2Vkl0cTFqL1loMGhlZGl5RTNJM2YvcmU2WFl4YnJYaVVH?=
 =?utf-8?B?UG5Pa013emd1VlEvMCszeDZSVFdvQjVUOVJybHpVa3dLN1V5OHFnSmRWREdX?=
 =?utf-8?B?WEI2NEVtTUxOZGx0aHdoOVpHa0s1YnNHYWVaTVBYV1hWbitRdWZIejZpTzY1?=
 =?utf-8?B?RFVkcTBUWXdqOWpVbHZYdS9ORjJrU1pySjFOUzZxMlJvQXBmS29jZDRLb0Jq?=
 =?utf-8?B?N2dFQzRYVDIwVXY1NldFUXR0aGt5WERaOXAwd3dPaWxQMUpNNzJjbHh3cFBq?=
 =?utf-8?B?ZVZCaEVqNnFMOWJPOHZwMnUyMk1HM2xPVjRXeG16Z2VwWEUxTmVmK2hBL3NL?=
 =?utf-8?Q?yRGT8NY3pjg=3D?=
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-80ceb.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 a596cd62-31ec-4021-c17d-08da39f30061
X-MS-Exchange-CrossTenant-AuthSource: PAXP193MB1533.EURP193.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 19 May 2022 23:55:07.6494
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P193MB0644
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/PAXP193MB15339A6E149E3CB509AD2827CAD09%40PAXP193MB1533.EURP193.PROD.OUTLOOK.COM>
Precedence: bulk

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 psql data_2020  -c "create table public.\"$tbl\" as 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