Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jy216-0001Il-Iw for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2020 23:49:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jy20a-0004Sq-32 for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2020 23:49:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jy20Z-0004Sj-TR for pgsql-docs@lists.postgresql.org; Tue, 21 Jul 2020 23:49:15 +0000 Received: from 3.mo64.mail-out.ovh.net ([46.105.34.112]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jy20X-0001M4-Pf for pgsql-docs@lists.postgresql.org; Tue, 21 Jul 2020 23:49:14 +0000 Received: from ex2.mail.ovh.net (unknown [10.109.146.184]) by mo64.mail-out.ovh.net (Postfix) with ESMTPS id DD23921D590 for ; Wed, 22 Jul 2020 01:49:09 +0200 (CEST) Received: from EX11.indiv2.local (172.16.2.11) by DAG006EX3.indiv2.local (172.16.2.32) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1979.3; Wed, 22 Jul 2020 01:49:09 +0200 Received: from EX11.indiv2.local ([fe80::69a9:5361:a272:635a]) by EX11.indiv2.local ([fe80::69a9:5361:a272:635a%15]) with mapi id 15.01.1979.003; Wed, 22 Jul 2020 01:49:08 +0200 From: PASCAL CROZET To: "pgsql-docs@lists.postgresql.org" Subject: RE: Additional Chapter for Tutorial Thread-Topic: Additional Chapter for Tutorial Thread-Index: AQHWFOGGJUvwmOo5Fk2bX8aXg4YQE6h9hA8AgAQMgQCADoTwAIAAU3GAgAEiOQCANAbxgIA/PVsAgAcfuQCAAhRAAIAEW7aAgADpAeY= Date: Tue, 21 Jul 2020 23:49:08 +0000 Message-ID: <5bee135488664b84acade4ba2c35d1ef@qualis-consulting.com> References: <13c65997-9502-7671-1a7b-50e5d5093514@purtz.de> <40aca6b45b0da614b94c8ef86d89b70b@xs4all.nl> <4b8bdb3b-10a7-e541-18ff-6a556ce89cd1@purtz.de> <9df5b9c8-71fe-47a8-4670-346a0ae7e2cd@purtz.de> <567f7c92-dce9-7424-9022-54b31eb12740@purtz.de> <1B5F7D1E-B389-4D3B-973A-A8D183D8530A@yesql.se> <766cab17c6af48956558611520956b77@xs4all.nl>, In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [77.141.240.231] Content-Type: multipart/alternative; boundary="_000_5bee135488664b84acade4ba2c35d1efqualisconsultingcom_" MIME-Version: 1.0 X-Ovh-Tracer-Id: 9148218220337014980 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeduiedrgeekgddviecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvufhtfffkfhgjihgtggesrgdtjhertddtheenucfhrhhomheprfetufevtefnucevtffqkgfgvfcuoehprghstggrlhdrtghrohiivghtsehquhgrlhhishdqtghonhhsuhhlthhinhhgrdgtohhmqeenucggtffrrghtthgvrhhnpeeftddvjeefkefggeeujeduteehteevleeftddtvdetvefhveevjeeuvefffffgheenucfkpheptddrtddrtddrtddpjeejrddugedurddvgedtrddvfedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmohguvgepshhmthhpqdhouhhtpdhhvghlohepvgigvddrmhgrihhlrdhovhhhrdhnvghtpdhinhgvtheptddrtddrtddrtddpmhgrihhlfhhrohhmpehprghstggrlhdrtghrohiivghtsehquhgrlhhishdqtghonhhsuhhlthhinhhgrdgtohhmpdhrtghpthhtohepphhgshhqlhdqughotghssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_5bee135488664b84acade4ba2c35d1efqualisconsultingcom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi all, I want to import XML file into PG database table. I've find functions to get the XML content of a cell after imported an XML = file with the pg_get_file function. But, I want to explode the XML content to colums. How can I do this ? PG 10 under Ubuntu 18 _________________________________ Cordialement, Pascal CROZET DBA - Qualis Consulting =95 300 Route Nationale 6 =96 69760 LIMONEST _________________________________ --_000_5bee135488664b84acade4ba2c35d1efqualisconsultingcom_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Hi all,


I want to import XML file into PG database table.

I've find functions to get the XML content of a cell after imported an X= ML file with the pg_get_file function.

But, I want to explode the XML content to colums. How can I do this ?


PG 10 under Ubuntu 18


_________________________________

Cordiale= ment, Pascal CROZET

DBA - Qualis Consulting

=95 300 Route Nationale 6 =96 69760 LIMONEST

_________________________________


--_000_5bee135488664b84acade4ba2c35d1efqualisconsultingcom_--