Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hbX67-0001YE-TX for psycopg@arkaria.postgresql.org; Thu, 13 Jun 2019 21:17:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hbX66-0003Zs-Mg for psycopg@arkaria.postgresql.org; Thu, 13 Jun 2019 21:17:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hbX66-0003Zk-G5 for psycopg@lists.postgresql.org; Thu, 13 Jun 2019 21:17:26 +0000 Received: from mail-eopbgr130074.outbound.protection.outlook.com ([40.107.13.74] helo=EUR01-HE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hbX64-0004uL-2a for psycopg@postgresql.org; Thu, 13 Jun 2019 21:17:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=TomTomInternational.onmicrosoft.com; s=selector2-TomTomInternational-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=U0TkhzBaYTkT6lVovoFyIHOroutJY1yN8wQYk9NdD9A=; b=PziMfKDwe45w4q1Nee2B9hZbwH5WAW9ayFrYQ/NeU/ObuMIPpeKADV40KV/PHrMrGYsW7/8jSUvkS8rtb6Tfd9il5i0G7bZNP2qW4tdRyqYdEesgbheQPi8h+plQUddy63jGlX+2yi6ZCMy+vWGBhGw3b2G0U7K2w/bDSfpVEv8= Received: from VI1PR07MB5792.eurprd07.prod.outlook.com (20.178.121.222) by VI1PR07MB3343.eurprd07.prod.outlook.com (10.175.244.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1987.8; Thu, 13 Jun 2019 21:17:17 +0000 Received: from VI1PR07MB5792.eurprd07.prod.outlook.com ([fe80::ad16:6144:69c6:513f]) by VI1PR07MB5792.eurprd07.prod.outlook.com ([fe80::ad16:6144:69c6:513f%7]) with mapi id 15.20.2008.006; Thu, 13 Jun 2019 21:17:17 +0000 From: David Raymond To: "psycopg@postgresql.org" Subject: RE: Creating dynamically-typed tables using psycopg2's built-in formatting Thread-Topic: Creating dynamically-typed tables using psycopg2's built-in formatting Thread-Index: AQHVIiGAcdhI0eJTcU+nrQxaoG80zKaaAP4AgAAPPoCAAAVjMA== Date: Thu, 13 Jun 2019 21:17:16 +0000 Message-ID: References: <33071EF2-86DE-4698-BFAA-6F084024A826@thebuild.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=David.Raymond@tomtom.com; x-originating-ip: [216.107.194.166] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 1bc5bb60-93b7-4088-cc9e-08d6f0448349 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(4652040)(8989299)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(5600148)(711020)(4605104)(1401327)(2017052603328)(7193020);SRVR:VI1PR07MB3343; x-ms-traffictypediagnostic: VI1PR07MB3343: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-forefront-prvs: 0067A8BA2A x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(136003)(396003)(39860400002)(376002)(346002)(366004)(189003)(199004)(8936002)(66066001)(476003)(7736002)(2906002)(305945005)(186003)(26005)(2351001)(5640700003)(11346002)(53546011)(33656002)(55016002)(102836004)(486006)(86362001)(6506007)(9686003)(6116002)(2501003)(14454004)(71190400001)(3846002)(76176011)(71200400001)(446003)(66476007)(5660300002)(1730700003)(4744005)(53936002)(81156014)(81166006)(6246003)(64756008)(7696005)(66556008)(76116006)(66946007)(25786009)(316002)(72206003)(66446008)(73956011)(68736007)(6916009)(99286004)(6436002)(8676002)(74316002)(256004)(229853002)(478600001)(52536014);DIR:OUT;SFP:1101;SCL:1;SRVR:VI1PR07MB3343;H:VI1PR07MB5792.eurprd07.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; received-spf: None (protection.outlook.com: tomtom.com does not designate permitted sender hosts) x-ms-exchange-senderadcheck: 1 x-microsoft-antispam-message-info: MzLaPsepJM+k/JPnIqvQOkhWVW0w3WeqRGzXjfCdPiaBrP8DeSwnHYUNKZIdwJdNerR+QOea97BRw5BC4CS6dgPSWiLqUZPdfZOydU8HnTSGSbTvoDtinJheM/Rtqjj5HAm3SmlyejDV8F5GDoeNkv8wU/z+cFuoV9FFNA+mCABLj4lV3fN/BOefr9UAxGmaAJ41PNeM9Hj01e9aZThK5MvymB1w9GSPMjs6ygu4sliCr7ESHSmcuGDkytVtbFNxBfm75mJde8cRpicwCb6x7p5kfpkA+8wtwXaWn7cTAIa2WNUMewzBeOiXlZE5xtlxyIk0phfffCoshvkLVUCJDlRKbke5zsxtjkxEeOfbAiw3l3xv4AB0gYbONYgpEU+UjT92PZMPnFhPekxEY6IUJCX/omc8QFjIW3vA++3T4z8= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: tomtom.com X-MS-Exchange-CrossTenant-Network-Message-Id: 1bc5bb60-93b7-4088-cc9e-08d6f0448349 X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Jun 2019 21:17:16.9678 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 374f8026-7b54-4a3a-b87d-328fa26ec10d X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: David.Raymond@tomtom.com X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR07MB3343 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Q291bGQgeW91IGxldCB1cyBrbm93IHdoYXQgdmVyc2lvbiB0aGUgc2VydmVyIGlzLCBhbmQgYWxz byBzaG93IGEgdGFibGUgbGlzdGluZz8gKENvbm5lY3Qgd2l0aCBwc3FsIGFuZCBkbyBhIFxkIGZv ciBleGFtcGxlKQ0KDQoNCkZyb206IERhbmllbCBDb2hlbiA8ZGFuaWVsLm0uY29oZW5AYmVya2Vs ZXkuZWR1PiANClNlbnQ6IFRodXJzZGF5LCBKdW5lIDEzLCAyMDE5IDQ6NTUgUE0NClRvOiBDaHJp c3RvcGhlIFBldHR1cyA8eG9mQHRoZWJ1aWxkLmNvbT4NCkNjOiBwc3ljb3BnQHBvc3RncmVzcWwu b3JnDQpTdWJqZWN0OiBSZTogQ3JlYXRpbmcgZHluYW1pY2FsbHktdHlwZWQgdGFibGVzIHVzaW5n IHBzeWNvcGcyJ3MgYnVpbHQtaW4gZm9ybWF0dGluZw0KDQpIaSBDaHJpc3RvcGhlLA0KDQpUaGFu a3Mgc28gbXVjaCBmb3IgeW91ciByZXNwb25zZS4gVGhlIHVwcGVyY2FzZSAtLT4gbG93ZXJjYXNl IGZpeCB3b3JrZWQgZm9yIHRoZSB0eXBlcywgYnV0IEknbSBzdGlsbCBvbmx5IGdldHRpbmcgdGFi bGVzIHRoYXQgY2FuIGJlIHNlYXJjaGVkIGJ5IGRvdWJsZS1xdW90YXRpb25zIChpLmUuID4gU0VM RUNUICogRlJPTSB0Ymw7IHJldHVybnMgbm90aGluZywgYnV0ID4gU0VMRUNUICogRlJPTSAidGJs IjsgcmV0dXJucyB0aGUgdGFibGUgSSB1cGxvYWRlZCkuIEkgY2FuJ3QgdGVsbCBmcm9tIHlvdXIg bWVzc2FnZSB3aGF0IHRoZSBzY3JpcHQgc2hvdWxkIHNheSB0byBmaXggdGhpcy4gVGhhbmsgeW91 IGFnYWluIQ0KDQpCZXN0LA0KDQpEYW5ueSANCg0K