Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVlEI-007HPs-0n for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 06:41:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVlEH-00AhqV-0B for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 06:41:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVlEG-00AhqL-2T for pgsql-hackers@lists.postgresql.org; Wed, 17 Dec 2025 06:41:45 +0000 Received: from mail-ua1-x933.google.com ([2607:f8b0:4864:20::933]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vVlEF-0016Jv-3C for pgsql-hackers@postgresql.org; Wed, 17 Dec 2025 06:41:44 +0000 Received: by mail-ua1-x933.google.com with SMTP id a1e0cc1a2514c-93f5905e60eso3315968241.0 for ; Tue, 16 Dec 2025 22:41:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765953703; x=1766558503; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=XQ39+h5j46qf7/qX/kueGUxK76kurtzbdC8LkUcCoCE=; b=TAEPXdzJCkhkS5T29CSzi4UNrtuOWXaaQ1lk3hiCNogbAeaNVO17vjgnV1/6z5GlZI VmhrUWduchGeXRPStvogGDWaxF3TpZMfuXIjHIBXgmWk0xNwdzrS56hQVpPJKARcUp/E Ib1PGiLdP55WYVe38GZGiHcVzOP9/R9iSUv3R6OVutl1r2tgEBTDhsrVjpfn2CGWV7WZ nNTnKBXgrsOtKckRywpipNU5GP47BCXcO27691WOcwY/HB87U96w2Qk2GGIhB/DUFZW5 RedAtYzeYprgfbMT0UGcQdtMqg3sFv29Xf0XqTVSe6zuC8Gi7GFXgdhKWdrU2jODhtf0 Dpzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765953703; x=1766558503; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=XQ39+h5j46qf7/qX/kueGUxK76kurtzbdC8LkUcCoCE=; b=I5X3/+479p7dPGYr96pMleN+MqZTDC6CkPb1OsPrqSFMBNLRXBNpwyKi2JgqL5JGMd 1lligo30fMFBBS7tcCLsxHFppddT/IR43wL5i5Ku9vc1H+3TEWXDhaLPRCwPcUdY3lWh u/5TBm9dRvGVsCmDXglhrXdRVW0w6SidZtBpSkJw6UNEjyblK+PECKAbyfTLZ//F8Lo2 A9pp/354eljGrkprJZE9HfPw6zRfQ8zPsKQJ0gbf9LvZs2tE5JIfe94bdzNR+DIonuVA dt7NKn24RYpb0bk0C8KKX857tZRF58leg2LaXRx2uCaSC1K4pbLlVxB4h16E8GihU7++ QRAg== X-Forwarded-Encrypted: i=1; AJvYcCWhY/yL8P17SxtBb1SaS/8ndddPJvNkhS/Y/pYFuT5DXOKWWbIy2IgUlSHILNvHM7fIonBTf9UfS12Q0adY@postgresql.org X-Gm-Message-State: AOJu0YxvoEXQHyzVQN3G7dvIaWME/gNcsgDd47fezQ9LL+S7pmB1seoU YDOQs2SlIDvN+8J59lVBhRAzzbujUj9I4DPRgxwcsKrlBd3/6ZGwrG5+1cypFO80YlPCnvJ59Uy OeuokzLVBmjXCcKE0a8XZxXIEZjCTOes= X-Gm-Gg: AY/fxX7lwv/Z18nnjpRhkOr0Cg4x2uBnT/8D0DaRpVU+5jsicnH7bhuGtCBNjD2/sNO TcbtFpolJRdhBTPi2DaJWdqbOSWQlBGmU5I+uju8ChZugb84k8p3WRcEY7HvRXQlw43kh2UG117 RuygWhGG7r2g/zR4z7Reo7vebsXU/djABUw14j2hErfAgZvZymHhrduHFLnSdC4Rj0aJ9GPjjDU F8LYKGO4B2QZoOBDpT76rlPzjK54D2Qm4SLnTO24AgrQG0H68f6/uBBcDiIix8NRgX2jjQYn5Hs t70OiXUjm6D7StLEgSzGoO8i5xVfOXuMNAxnjMWBc4I8QaY3+/rP+MIi9n4RcGzOZgUbn7uB3G7 HX2dtMS2mYXgmErlG3ipPYPpk//V9rAb9TU31w8ZN46qDOd6U9BcsTqAg7xOdhJnLfT8/tW+O3X kCeTL54XM3VchjHvfH0g== X-Google-Smtp-Source: AGHT+IF2cytBcJxMdUWuRTyaJ4ryUGkAIOcURoh3Vqc4w+4POAP++T5omCC3FfdtDVcSJNN0imaAmJGhXSJbvLcHckU= X-Received: by 2002:a05:6102:a51:b0:5db:d487:2ef8 with SMTP id ada2fe7eead31-5e8277b38fcmr6937175137.20.1765953702800; Tue, 16 Dec 2025 22:41:42 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: jian he Date: Wed, 17 Dec 2025 14:41:06 +0800 X-Gm-Features: AQt7F2oyq6GKUILSi3JJgzPsD6-T6tcnVKLXW21Vl8lTw7WgaCEwhUEFkHirIf0 Message-ID: Subject: Re: create table like including storage parameter To: Euler Taveira Cc: Nathan Bossart , "David G. Johnston" , pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, current, v7 the DOC changes: + + INCLUDING PARAMETERS + + + All table parameters, such as the storage parameter + settings of the source table, will be copied. For table storage + parameters, see + below for more information. + + + https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-SET-ATTRIBUTE-OPTION Does the "parameter" (INCLUDING PARAMETERS) definition is close to "option"? This raises the question of whether we should also copy column-level options to the new table. What do you think? -- jian https://www.enterprisedb.com