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 1pxTwv-00082S-Vn for pgsql-general@arkaria.postgresql.org; Fri, 12 May 2023 14:40:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pxTwu-0008B9-Rl for pgsql-general@arkaria.postgresql.org; Fri, 12 May 2023 14:40:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pxTwu-0008B0-6q for pgsql-general@lists.postgresql.org; Fri, 12 May 2023 14:40:48 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pxTwq-002DvM-TJ for pgsql-general@lists.postgresql.org; Fri, 12 May 2023 14:40:47 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id DE0D65F7B7; Fri, 12 May 2023 10:40:38 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snowman.net; s=dkim; t=1683902438; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=aRe8IhEtUE8lGN9UvmOtd67iroFEP388haLqp5I0LCk=; b=p6TSYabkPG10ULdt4BbiwjCcn+GezIDeIFTrlVZJ3rnlNNH9IzvSuf4nyO5PrMm5pZLfrh h9lmLiG1o9Y14FhoxYRX46UxprBUDe4s4zLeAXRQpcUj7aO+qFPW3XLg2i+le574MR7itd wbeW25dB3YTIYDYoAPHkMOQ718ly8MI= Date: Fri, 12 May 2023 10:40:38 -0400 From: Stephen Frost To: Nathaniel Sabanski Cc: pgsql-general@lists.postgresql.org Subject: Re: Adding SHOW CREATE TABLE Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="BNQ0IqjZ6enEVoMr" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --BNQ0IqjZ6enEVoMr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, Please don't top-post on these lists. * Nathaniel Sabanski (sabanski.n@gmail.com) wrote: > I believe most users would anticipate a CREATE TABLE statement that aligns > with the currently installed version- this is the practical solution for > the vast majority. Perhaps a bit more discussion about what exactly the use-case is would be helpful- what would you use this feature for? > In situations where a CREATE TABLE statement compatible with an older > version of Postgres is required, users can opt for an additional step of > using tools like pg_dump or an older version of Postgres itself. This > allows them to ensure compatibility without compromising the practicality > of the process. The issue is really both older and newer versions, not just older ones and not just newer ones. To the extent you're interested in this, I pointed out where you could go look at the existing code as well as an idea for how to move this forward. Thanks, Stephen --BNQ0IqjZ6enEVoMr Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmReT+QACgkQ7WyKOINH ZFXw1g/7BVXbv4YXENQ6DADOifQpaJ8iyZfJIne3TB+W19FfNuKbYMJ/ZAW2LZvC +jix5qxlUWm3uUtOeDn2rj53GQiq0oyCKBiY186dt3BZZeFVMHhLngqDCzW1SUzH 5ducX6nk8MbUeB15jjER4vB4DbvuQPH2rcMUt0uo3KRUzMRmAfe+wSynBQHQ/tKi qZQA8iULpE2cHm1WUCeDc5tB1UDgICv6C/LQLsREkhFjgyVczzjUM45oBFmOU9j/ tubAgQp+f+v9QDtMZ94BL2IA05IfMBrWqYIsqJycAGr+k1T8ylj+zxkUOpKXMu2T /jc4FIfp38WzxfuBLWttZE7YbJDPDJrIDb7A6G26I5uD9OoWoPiBG/zScp9O11eU aERnFMpdg3xDbbJUw8w2iIAvAIbn1Igp0JG6/3YmUTpSpeFgZny/XukPmq8MK3Er sHyKonlaniGW0NMuaTr5OnvNWh975YWSHMbt4jdhIYF3CP4aCoQrMHOMyXB6gtbG grHiASVSMucnOVAqDa+lshCcRQLZWd8GdiptBeQtlz8YOO19/AGoy0aNSy18hTXQ bDAbY6wzOWi6X6O/r+n7ZP6RKZFBbZGUE4Wkdh0aZIafJ6JyrsrSRNiK6rra1qG0 rJ+zy/4cQV1om2EIqV4ki6PuUf9CfODmu/s6GbCaJfFLFBy7O90= =ULML -----END PGP SIGNATURE----- --BNQ0IqjZ6enEVoMr--