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 1hbWLO-0008DR-NW for psycopg@arkaria.postgresql.org; Thu, 13 Jun 2019 20:29:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hbWLN-0007zw-Jc for psycopg@arkaria.postgresql.org; Thu, 13 Jun 2019 20:29:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hbWLN-0007y4-5E for psycopg@lists.postgresql.org; Thu, 13 Jun 2019 20:29:09 +0000 Received: from mail-eopbgr00068.outbound.protection.outlook.com ([40.107.0.68] helo=EUR02-AM5-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hbWLK-0007tn-CU for psycopg@postgresql.org; Thu, 13 Jun 2019 20:29:08 +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=CcsAaEjXWyINlLfhdPF3WN9C9qliSIN6ZfvcXynXME8=; b=Bc99AP7xctBFEMr/oszY7OjaCF2pBuEG4OXnkMgSQfnd1wvnjuiF3a/OQaJNyFJh/FZna/jSPTxcdfcmcNJaBjrcPObBMBlCbLNmSZqAkMqg1S73tzxSX2EPr20XJY1uQKG17aBfZgyHAN4pP3HEFbM7D2+3RTERlfcr07oRJ9c= Received: from VI1PR07MB5792.eurprd07.prod.outlook.com (20.178.121.222) by VI1PR07MB4558.eurprd07.prod.outlook.com (20.177.56.203) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1987.7; Thu, 13 Jun 2019 20:29:04 +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 20:29:04 +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+nrQxaoG80zKaaBGaQ Date: Thu, 13 Jun 2019 20:29:04 +0000 Message-ID: References: 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: ad1ae34a-e16f-49ce-2573-08d6f03dc70d x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(4652040)(8989299)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(5600148)(711020)(4605104)(1401327)(2017052603328)(7193020);SRVR:VI1PR07MB4558; x-ms-traffictypediagnostic: VI1PR07MB4558: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7219; x-forefront-prvs: 0067A8BA2A x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(39860400002)(346002)(366004)(376002)(396003)(136003)(199004)(189003)(476003)(5660300002)(11346002)(52536014)(86362001)(229853002)(2351001)(55016002)(66574012)(486006)(316002)(5640700003)(53936002)(9686003)(4744005)(102836004)(2906002)(72206003)(99286004)(71190400001)(74316002)(7736002)(305945005)(478600001)(6436002)(446003)(6916009)(26005)(76116006)(3846002)(2501003)(14454004)(6116002)(256004)(66446008)(76176011)(71200400001)(66946007)(6506007)(73956011)(64756008)(1730700003)(66476007)(81166006)(81156014)(66066001)(8676002)(8936002)(33656002)(25786009)(68736007)(186003)(66556008)(7696005)(6246003);DIR:OUT;SFP:1101;SCL:1;SRVR:VI1PR07MB4558;H:VI1PR07MB5792.eurprd07.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX: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: XWkqRRndYn4h7FgyF8w/R4MID+O9n1kRm/W30da+qBQsdkfoDMgkbndHo0IWSgErM3r4Xrcb3d2oLKTRuFTtxN/cRXG0okAPjgRcYOlo6D8o/RRvxz9iH2tugzcADnMB+zGpDw/n8QmzgVRPXAYkOOAnH86NyoZnDpKylEt3DvZdtuhWbR+2h/B1IaIdEWO6FQtIvt1T25CP57hIp2gcZjxQIVDZUOTFKuiaMENcly/wE8kcefog4MimQBn2cyZxb9UTbwf7wFDsWLSpB0SR2APWmBxzGPvWYGYIFxWTztlcbYuXfK6vgsroQREqNOn4rLo0sMqSKq+KDygFY5Fo1aCdMGesWM4SKrGK6LNOkkO5DgRRZSn1Vr0J62uuUKeutA8B9TyCtJ/U3/dBpX4gVZ+i90xNcTBHZNQpISPQI8w= 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: ad1ae34a-e16f-49ce-2573-08d6f03dc70d X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Jun 2019 20:29:04.1173 (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: VI1PR07MB4558 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk U0VMRUNUICogRlJPTSB0Ymw7DQpyZXR1cm5zIGEgdG90YWxseSBkaWZmZXJlbnQgdGFibGUgdGhh bg0KU0VMRUNUICogRlJPTSAidGJsIjsNCg0KVGhhdCdzIGEgbGl0dGxlIGRpc2NvbmNlcnRpbmcu DQoNCkZvciB0aGUgY2FwaXRhbGl6YXRpb24gdGhpbmcgYmFzaWNhbGx5IHdoYXQncyBnb2luZyBv biBpcyB0d28gdGhpbmdzLiAoVGhlIHdheSBJIHVuZGVyc3RhbmQgaXQpDQoxKSBQb3N0Z3JlcyBJ UyBjYXNlIHNlbnNpdGl2ZS4NCjIpIFdoZW4gYW55IHF1ZXJ5IGdldHMgc2VudCB0byB0aGUgc2Vy dmVyLCB0aGUgc2VydmVyIGNvbnZlcnRzIGV2ZXJ5dGhpbmcgbm90IGluc2lkZSBxdW90ZXMgdG8g bG93ZXIgY2FzZSBhcyBzdGVwIDEsIF9iZWZvcmVfIHRyeWluZyB0byBtYXRjaCBuYW1lcyBmb3Ig dGFibGVzLCBjb2x1bW5zLCBmdW5jdGlvbnMsIGV0Yy4NCg0KDQpTbyBpZiB5b3Ugc2VuZA0KU0VM RUNUICogRlJPTSBUQkw7DQpPbmUgb2YgdGhlIGZpcnN0IHRoaW5ncyB0aGUgc2VydmVyIGRvZXMg aXMgY2hhbmdlIGl0IHRvDQpzZWxlY3QgKiBmcm9tIHRibDsNCmF0IHdoaWNoIHBvaW50IGl0IHdp bGwgZG8gYSBjYXNlLXNlbnNpdGl2ZSBtYXRjaCBmb3IgdGJsDQoNCkFuZCBpZiB5b3UgcnVuDQpT RUxFQ1QgKiBGUk9NICJUQkwiOw0KaXQgZ2V0cyB0dXJuZWQgaW50bw0Kc2VsZWN0ICogZnJvbSAi VEJMIjsNCmF0IHdoaWNoIHBvaW50IGl0IHdpbGwgZG8gYSBjYXNlLXNlbnNpdGl2ZSBtYXRjaCBm b3IgVEJMDQoNCkJ1dCBpbiB5b3VyIGNhc2Ugd2hhdCBpcyBpbiBxdW90ZXMgaXMgdGhlIHNhbWUg YXMgaXRzIGxvd2VyY2FzZSB2ZXJzaW9uLiBTbyBpdCAic2hvdWxkIiBtYXRjaCB1cCB0byB0aGUg c2FtZSB0aGluZy4gU28gaWYgeW91IGFyZSBpbmRlZWQgZ2V0dGluZyBkaWZmZXJlbnQgcmVzdWx0 cyBmcm9tIGRpZmZlcmVudCB0YWJsZXMgdGhlbiBlaXRoZXIgbXkgdW5kZXJzdGFuZGluZyBpcyB3 YXkgb2ZmLCBvciBzb21ldGhpbmcgd2VpcmQgaXMgZ29pbmcgb24uDQo=