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 1kAor9-0005rS-Tb for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2020 06:24:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kAor7-0006Rs-6o for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2020 06:24:21 +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 1kAor6-0006Rl-JT for pgsql-docs@lists.postgresql.org; Wed, 26 Aug 2020 06:24:20 +0000 Received: from forward101o.mail.yandex.net ([37.140.190.181]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kAoqy-0005JV-IB for pgsql-docs@lists.postgresql.org; Wed, 26 Aug 2020 06:24:19 +0000 Received: from mxback6o.mail.yandex.net (mxback6o.mail.yandex.net [IPv6:2a02:6b8:0:1a2d::20]) by forward101o.mail.yandex.net (Yandex) with ESMTP id B27833C023F8; Wed, 26 Aug 2020 09:24:08 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback6o.mail.yandex.net (mxback/Yandex) with ESMTP id FZ1luQjlEW-O7fC8PMl; Wed, 26 Aug 2020 09:24:08 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1598423048; bh=IW/kpXgOZ8yeh4e3HUKbyPN4mP9gCbcArz3CiGDANxE=; h=References:Date:Message-Id:Cc:Subject:To:From; b=OEIuUR7gCPIXtL7ijEQ5SrItROl7D+3nXaTDu7jOOCjMBeHI63NnImQPDgczNR57B xedfl0ViMW+D1hqgdomRbcmZyUy8oVfQVN8+JckdokLXGRJ/VWJvfI25ocrKMYm00l +z1Sfo1aG7burfyFN/gnzy9DjcdKBo/VwXUKjUmk= Authentication-Results: mxback6o.mail.yandex.net; dkim=pass header.i=@yandex.ru Received: by myt4-eb6256e01f8b.qloud-c.yandex.net with HTTP; Wed, 26 Aug 2020 09:24:07 +0300 From: =?utf-8?B?0J3QuNC60L7Qu9Cw0Lkg0KfQsNC00LDQtdCy?= To: =?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= , Bruce Momjian Cc: David G. Johnston , Pg Docs References: <159800192078.2886.10431506404995508950@wrigleys.postgresql.org> <20200821215807.GE13363@momjian.us> <20200822175156.GG26781@momjian.us> <20200824150725.GJ26781@momjian.us> Subject: Re: Create a Foreign Table for PostgreSQL CSV Logs MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 26 Aug 2020 09:24:07 +0300 Message-Id: <7945231598336283@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5UaGFuayBZb3UgT2xlZy48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5BIHNpbXBsZSBleGFt cGxlIGlzIGV4dHJlbWVseSBpbXBvcnRhbnQgYW5kIG5lY2Vzc2FyeS48L2Rpdj48ZGl2Pkkgd2ls bCB3YWl0IGZvciB0aGlzIGV4YW1wbGUuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+LS3CoDwvZGl2 PjxkaXY+TmljayBDaGFkYWV2PGRpdj7CoDwvZGl2PjxkaXY+wqDCoMKgwqDCoCArNyg5MTYpMTc1 LTMwNjE8L2Rpdj48ZGl2PsKgwqDCoMKgwqAgKzcoOTU4KTgyMC03OTc1PC9kaXY+PGRpdj7CoDwv ZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MjQuMDguMjAy MCwgMTg6MzgsICLQntC70LXQsyDQodCw0LzQvtC50LvQvtCyIiAmbHQ7PGEgaHJlZj0ibWFpbHRv OnNwbGFydkB5YS5ydSI+c3BsYXJ2QHlhLnJ1PC9hPiZndDs6PC9kaXY+PGJsb2NrcXVvdGU+PHA+ PGJyIC8+wqA8L3A+PGJsb2NrcXVvdGU+wqAyNCDQsNCy0LMuIDIwMjAg0LMuLCDQsiAxODowNywg QnJ1Y2UgTW9tamlhbiAmbHQ7PGEgaHJlZj0ibWFpbHRvOmJydWNlQG1vbWppYW4udXMiPmJydWNl QG1vbWppYW4udXM8L2E+Jmd0OyDQvdCw0L/QuNGB0LDQuyjQsCk6PGJyIC8+wqA8YnIgLz7CoE9u IE1vbiwgQXVnIDI0LCAyMDIwIGF0IDA3OjQwOjQ5QU0gLTA3MDAsIERhdmlkIEcuIEpvaG5zdG9u IHdyb3RlOjxibG9ja3F1b3RlPsKgT24gTW9uLCBBdWcgMjQsIDIwMjAgYXQgNjoxNyBBTSDQntC7 0LXQsyDQodCw0LzQvtC50LvQvtCyICZsdDs8YSBocmVmPSJtYWlsdG86c3BsYXJ2QHlhLnJ1Ij5z cGxhcnZAeWEucnU8L2E+Jmd0OyB3cm90ZTo8YnIgLz7CoDxiciAvPsKgwqDCoMKgVGhlcmUgbXVz dCBub3QgYmUgY29uc3RyYWludHMgYXQgYWxsLiBDb25zdHJhaW50cyBhcmUgbmVlZGVkIHRvIGNo ZWNrPGJyIC8+wqDCoMKgwqBpbmNvbWluZyBkYXRhIHRvIHRoZSB0YWJsZS4gQnV0IGhlcmUgdGFi bGUgaXMgcmVhZC1vbmx5IGZvciBkYXRhYmFzZSE8YnIgLz7CoDxiciAvPsKgPGJyIC8+wqBQbGVh c2UgZG9uJ3QgdG9wLXBvc3QuPGJyIC8+wqA8YnIgLz7CoDxiciAvPsKgPGJyIC8+wqDCoMKgwqBT byBhbGwgeW91ciBjb25zdHJhaW50cyBpcyB0b3RhbGx5IHVzZWxlc3MuPGJsb2NrcXVvdGU+PGJs b2NrcXVvdGU+wqBjb3VsZCBiZWNvbWU6PGJyIC8+wqA8YnIgLz7CoGNvbm5lY3Rpb25fZnJvbSB0 ZXh0IGNoZWNrKGNvbm5lY3Rpb25fZnJvbSB+ICdeW146XSs6WzAtOV0rJCkgLS0gdGhlPC9ibG9j a3F1b3RlPjwvYmxvY2txdW90ZT7CoMKgwqDCoGhvc3QgYW5kPGJsb2NrcXVvdGU+PGJsb2NrcXVv dGU+wqBwb3J0IG9mIHRoZSBjbGllbnQsIGNvbG9uLXNlcGFyYXRlZDwvYmxvY2txdW90ZT48L2Js b2NrcXVvdGU+wqA8YnIgLz7CoDxiciAvPsKgSSdsbCBhZ3JlZSB0aGF0IHRoZSBiZW5lZml0IGZv ciBhZGRpbmcgdGhlIGNvbnN0cmFpbnRzIHRvIGEgZm9yZWlnbiB0YWJsZSBhcmU8YnIgLz7CoGxl c3MgdGhhbiBmb3IgYSBub3JtYWwgdGFibGUgYnV0IGl0IGlzIHN0aWxsIG5vdCB6ZXJvLiBDb25z dHJhaW50cyBhcmUgYWxzbyBhPGJyIC8+wqBmb3JtIG9mIGRvY3VtZW50YXRpb24uIEFuZCBhbHNv IGNhbiBiZSB1c2VkIChhdCBsZWFzdCBub24tbnVsbCBvbmVzKSBkdXJpbmc8YnIgLz7CoG9wdGlt aXphdGlvbi48L2Jsb2NrcXVvdGU+wqA8YnIgLz7CoEkgZmVlbCBjb25zdHJhaW50cyBhcmUgZ29p bmcgdG8gbG9zZSBmb2N1cyBvZiB3aGF0IHdlIGFyZSB0cnlpbmcgdG88YnIgLz7CoHNob3cuIERv IHRoZSBjb25zdHJhaW50cyBhY3R1YWxseSBkbyBhbnl0aGluZyBvbiBhIGZvcmVpZ24gdGFibGU/ PC9ibG9ja3F1b3RlPjxwPjxiciAvPkknbGwgYWRkOiAib24gZm9yZWlnbiB0YWJsZSBiYXNlZCBv biByZWFkIG9ubHkgdGV4dCBmaWxlIHdpdGhvdXQgaW5kZXhlcywgZXRjIi4gOikgQnV0IGluIHRo aXMgY2FzZSBJIGluZGVlZCBhZGRlZCBzb21lIENIRUNLKCkgY29uc3RyYWludHMgZm9yIG9sZCBQ b3N0Z3JlU1FMIGFuZCBjaGFuZ2UgdGhlbSBmb3IgdGhlIHBhcnRpdGlvbiBzeW50YXggc3VnYXIg b24gbmV3IFBvc3RncmVTUUwgdG8gcG9pbnQgb24gZGlmZmVyZW50IGZpbGVzIGFjY29yZGluZyB0 byBQb3N0Z3JlU1FMIGRlZmF1bHQgbG9nIGNvbmZpZywgd2hlcmUgbG9ncyBvZiBlYWNoIGRheSBv ZiBhIHdlZWsgaXMga2VwdCBpbiB0aGUgZGlmZmVyZW50IGZpbGVzLiBGb3IgZXhhbXBsZTo8YnIg Lz48YnIgLz5BTFRFUiBTWVNURU0gU0VUIGxvZ19kZXN0aW5hdGlvbj1jc3Zsb2c7PGJyIC8+U0VM RUNUIHBnX3JlbG9hZF9jb25mKCk7PGJyIC8+Q1JFQVRFIEVYVEVOU0lPTiBmaWxlX2Zkdzs8YnIg Lz5DUkVBVEUgU0VSVkVSIGZpbGVfZmR3IEZPUkVJR04gREFUQSBXUkFQUEVSIGZpbGVfZmR3Ozxi ciAvPkJFR0lOOzxiciAvPkNSRUFURSBTQ0hFTUEgcGdsb2c7PGJyIC8+Q1JFQVRFIFRBQkxFIHBn bG9nLnBnbG9nICg8YnIgLz7CoMKgwqDCoMKgwqDCoMKgbG9nX3RpbWUgdGltZXN0YW1wKDMpLDxi ciAvPsKgwqDCoMKgwqDCoMKgwqB1c2VyX25hbWUgdGV4dCw8YnIgLz7CoMKgwqDCoMKgwqDCoMKg ZGF0YWJhc2VfbmFtZSB0ZXh0LDxiciAvPsKgwqDCoMKgwqDCoMKgwqBwcm9jZXNzX2lkIGludGVn ZXIsPGJyIC8+wqDCoMKgwqDCoMKgwqDCoGNvbm5lY3Rpb25fZnJvbSB0ZXh0LDxiciAvPsKgwqDC oMKgwqDCoMKgwqBzZXNzaW9uX2lkIHRleHQsPGJyIC8+wqDCoMKgwqDCoMKgwqDCoHNlc3Npb25f bGluZV9udW0gYmlnaW50LDxiciAvPsKgwqDCoMKgwqDCoMKgwqBjb21tYW5kX3RhZyB0ZXh0LDxi ciAvPsKgwqDCoMKgwqDCoMKgwqBzZXNzaW9uX3N0YXJ0X3RpbWUgdGltZXN0YW1wIHdpdGggdGlt ZSB6b25lLDxiciAvPsKgwqDCoMKgwqDCoMKgwqB2aXJ0dWFsX3RyYW5zYWN0aW9uX2lkIHRleHQs PGJyIC8+wqDCoMKgwqDCoMKgwqDCoHRyYW5zYWN0aW9uX2lkIGJpZ2ludCw8YnIgLz7CoMKgwqDC oMKgwqDCoMKgZXJyb3Jfc2V2ZXJpdHkgdGV4dCw8YnIgLz7CoMKgwqDCoMKgwqDCoMKgc3FsX3N0 YXRlX2NvZGUgdGV4dCw8YnIgLz7CoMKgwqDCoMKgwqDCoMKgbWVzc2FnZSB0ZXh0LDxiciAvPsKg wqDCoMKgwqDCoMKgwqBkZXRhaWwgdGV4dCw8YnIgLz7CoMKgwqDCoMKgwqDCoMKgaGludCB0ZXh0 LDxiciAvPsKgwqDCoMKgwqDCoMKgwqBpbnRlcm5hbF9xdWVyeSB0ZXh0LDxiciAvPsKgwqDCoMKg wqDCoMKgwqBpbnRlcm5hbF9xdWVyeV9wb3MgaW50ZWdlciw8YnIgLz7CoMKgwqDCoMKgwqDCoMKg Y29udGV4dCB0ZXh0LDxiciAvPsKgwqDCoMKgwqDCoMKgwqBxdWVyeSB0ZXh0LDxiciAvPsKgwqDC oMKgwqDCoMKgwqBxdWVyeV9wb3MgaW50ZWdlciw8YnIgLz7CoMKgwqDCoMKgwqDCoMKgbG9jYXRp b24gdGV4dCw8YnIgLz7CoMKgwqDCoMKgwqDCoMKgYXBwbGljYXRpb25fbmFtZSB0ZXh0PGJyIC8+ KSBQQVJUSVRJT04gQlkgTElTVCAoZGF0ZV9wYXJ0KCdpc29kb3cnLCBsb2dfdGltZSkpOzxiciAv PkNSRUFURSBGT1JFSUdOIFRBQkxFIHBnbG9nLk1vbjxiciAvPsKgwqDCoMKgwqDCoMKgwqBQQVJU SVRJT04gT0YgcGdsb2cucGdsb2cgRk9SIFZBTFVFUyBJTiAoMSk8YnIgLz7CoMKgwqDCoMKgwqDC oMKgU0VSVkVSIGZpbGVfZmR3PGJyIC8+wqDCoMKgwqDCoMKgwqDCoE9QVElPTlMgKCBmaWxlbmFt ZSAnL3Zhci9saWIvcGdzcWwvMTIvZGF0YS9sb2cvcG9zdGdyZXNxbC1Nb24uY3N2JywgZm9ybWF0 ICdjc3YnICk7PGJyIC8+Q1JFQVRFIEZPUkVJR04gVEFCTEUgcGdsb2cuVHVlPGJyIC8+wqDCoMKg wqDCoMKgwqDCoFBBUlRJVElPTiBPRiBwZ2xvZy5wZ2xvZyBGT1IgVkFMVUVTIElOICgyKTxiciAv PsKgwqDCoMKgwqDCoMKgwqBTRVJWRVIgZmlsZV9mZHc8YnIgLz7CoMKgwqDCoMKgwqDCoMKgT1BU SU9OUyAoIGZpbGVuYW1lICcvdmFyL2xpYi9wZ3NxbC8xMi9kYXRhL2xvZy9wb3N0Z3Jlc3FsLVR1 ZS5jc3YnLCBmb3JtYXQgJ2NzdicgKTs8YnIgLz5DUkVBVEUgRk9SRUlHTiBUQUJMRSBwZ2xvZy5X ZWQ8YnIgLz7CoMKgwqDCoMKgwqDCoMKgUEFSVElUSU9OIE9GIHBnbG9nLnBnbG9nIEZPUiBWQUxV RVMgSU4gKDMpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoFNFUlZFUiBmaWxlX2ZkdzxiciAvPsKgwqDC oMKgwqDCoMKgwqBPUFRJT05TICggZmlsZW5hbWUgJy92YXIvbGliL3Bnc3FsLzEyL2RhdGEvbG9n L3Bvc3RncmVzcWwtV2VkLmNzdicsIGZvcm1hdCAnY3N2JyApOzxiciAvPkNSRUFURSBGT1JFSUdO IFRBQkxFIHBnbG9nLlRodTxiciAvPsKgwqDCoMKgwqDCoMKgwqBQQVJUSVRJT04gT0YgcGdsb2cu cGdsb2cgRk9SIFZBTFVFUyBJTiAoNCk8YnIgLz7CoMKgwqDCoMKgwqDCoMKgU0VSVkVSIGZpbGVf ZmR3PGJyIC8+wqDCoMKgwqDCoMKgwqDCoE9QVElPTlMgKCBmaWxlbmFtZSAnL3Zhci9saWIvcGdz cWwvMTIvZGF0YS9sb2cvcG9zdGdyZXNxbC1UaHUuY3N2JywgZm9ybWF0ICdjc3YnICk7PGJyIC8+ Q1JFQVRFIEZPUkVJR04gVEFCTEUgcGdsb2cuRnJpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoFBBUlRJ VElPTiBPRiBwZ2xvZy5wZ2xvZyBGT1IgVkFMVUVTIElOICg1KTxiciAvPsKgwqDCoMKgwqDCoMKg wqBTRVJWRVIgZmlsZV9mZHc8YnIgLz7CoMKgwqDCoMKgwqDCoMKgT1BUSU9OUyAoIGZpbGVuYW1l ICcvdmFyL2xpYi9wZ3NxbC8xMi9kYXRhL2xvZy9wb3N0Z3Jlc3FsLUZyaS5jc3YnLCBmb3JtYXQg J2NzdicgKTs8YnIgLz5DUkVBVEUgRk9SRUlHTiBUQUJMRSBwZ2xvZy5TYXQ8YnIgLz7CoMKgwqDC oMKgwqDCoMKgUEFSVElUSU9OIE9GIHBnbG9nLnBnbG9nIEZPUiBWQUxVRVMgSU4gKDYpPGJyIC8+ wqDCoMKgwqDCoMKgwqDCoFNFUlZFUiBmaWxlX2ZkdzxiciAvPsKgwqDCoMKgwqDCoMKgwqBPUFRJ T05TICggZmlsZW5hbWUgJy92YXIvbGliL3Bnc3FsLzEyL2RhdGEvbG9nL3Bvc3RncmVzcWwtU2F0 LmNzdicsIGZvcm1hdCAnY3N2JyApOzxiciAvPkNSRUFURSBGT1JFSUdOIFRBQkxFIHBnbG9nLlN1 bjxiciAvPsKgwqDCoMKgwqDCoMKgwqBQQVJUSVRJT04gT0YgcGdsb2cucGdsb2cgRk9SIFZBTFVF UyBJTiAoNyk8YnIgLz7CoMKgwqDCoMKgwqDCoMKgU0VSVkVSIGZpbGVfZmR3PGJyIC8+wqDCoMKg wqDCoMKgwqDCoE9QVElPTlMgKCBmaWxlbmFtZSAnL3Zhci9saWIvcGdzcWwvMTIvZGF0YS9sb2cv cG9zdGdyZXNxbC1TdW4uY3N2JywgZm9ybWF0ICdjc3YnICk7PGJyIC8+Q09NTUlUOzxiciAvPjxi ciAvPkJ1dCB0aGVyZSBpcyBhbm90aGVyIHBvaW50IG9mIHZpZXcuIFRoZSBzYW1lIHRhYmxlIHNj aGVtYSB1c2VkIG5vdyBub3Qgb25seSBmb3IgZmlsZV9mZHcgYWNjZXNzIHRvIHRoZSBsb2csIGJ1 dCBhbHNvIGluIGV4YW1wbGUgd2hlcmUgdGhpcyBpcyBhbiBvcmRpbmFyeSB0YWJsZS4gSW4gdGhp cyBjYXNlIG1heSBiZSBzb21lIG90aGVyIG9wdGltaXNhdGlvbjogaW5kZXhlcywgZXRjLjxiciAv PjxiciAvPkJ1dCBkbyB3ZSByZWFsbHkgbmVlZCBpbiB0aGUgc2ltcGxlIGV4YW1wbGUgc3VjaCBk ZXRhaWxlZCBhbmQgc3BlY2lmaWMgY29kZT8gTWF5IGJlIGJldHRlciBnaXZlIGFzIHNpbXBsZSBh cyBwb3NzaWJsZSBleGFtcGxlIGFzIGV4YW1wbGUsIHdoaWNoIGV2ZXJ5b25lIHdpbGwgY2FuIGFk YXB0IGZvciBoaXMgb3duIG5lZWRzLjwvcD48L2Jsb2NrcXVvdGU+PC9kaXY+