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 1vr5PS-00688W-1q for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 02:29:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vr5PR-00GuiJ-1c for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 02:29:25 +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 1vr5PR-00GuiB-0a for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 02:29:25 +0000 Received: from mail-yx1-xb12f.google.com ([2607:f8b0:4864:20::b12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vr5PO-00000000XXD-1miu for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 02:29:24 +0000 Received: by mail-yx1-xb12f.google.com with SMTP id 956f58d0204a3-649e97f1e99so1486212d50.2 for ; Fri, 13 Feb 2026 18:29:23 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771036161; cv=none; d=google.com; s=arc-20240605; b=UY7blEL+iaEqb/echCLYxOTgXHPoVesQA+9ItOe8cn3yBVxPoLATHvLVyzgQHjrpLZ TpF5MopY+hfxT4GlgOyFwkKycUset+bRnSjySmbLuzFv99etgO0l6Ut5dlvNb8+LuRnE sxaf/HtSxcMmMhHXz+ufQVvGCiGTDtJkq+m1QNUt789uWP3kxNXprBgmLKMEN+DtNwSl 8n82ngwoAEiE4jWF5nDXKm5MOoLnvuGSocR0Uv8N5v3tRFZ8AakZD1yNBG++eDKURWeX B6OnB2W2OuS9AspjUpzB8tX6VCy32ihJOTUZVCekUBXuek5dkzHeehc16WE8PiKfK4/k LKtA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; fh=2DoGC78b0mi8uZ4UY+9ocPF86GSVzeaJWqou/x907js=; b=JBpG2ONIzO/hGp4XG2x/uYqZ6mD8pFvlR1YicypOpcY5VHdhkEIBHQwOWEe43+M0en wVLCB1bho6LefYqnwNAAuR4UGVy/8jkUq/2HBSofv+QnzGISWXQBr1T4KfudRuh++q1H fR1riFEOfH8nnoP32kg3ZtrxFnSMJKilBszA78Dt7Mln70A2AeEaKrPgmy3wptsCoYv4 886DiAPpv/IHmXQG7nm6DlIpMb+BAUfA1Yw5NYJeqZhEne37X8EYuIw9LPw0Vs1gOqkT 4JUo6FXB3FjKGs/Q/DVPQTllE/Sule5IusFLQKMFs+Vaxv+FQ+7sP3EE3Eg40sx6rftT +zNw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771036161; x=1771640961; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; b=GKHG4gFCCGzOfUf5BdNx2rsPETmi5+7Xnk03crCtx/6OmGp6DqK6goXMlCqyFvd04i 71VYdfTMzZoaPScYH+A/FDWVD1k2uyFUzgTg0hVzbOCfhIxtds6orGKHoyHA3vBMvuAp T31tCcVq4EqiRPa2s6ZhA4XzM/+qnSCA3sNMupfvtDAHuLMYCSzTYEMPkmQfZbjFJjQM 5pnAiAz5cdOjAoHXcjpNGkXtPwQQfJBbSKXH0peZtAcQpKY2JD2j98swxyTJrrw5/DjB Y1TxupSTuI6mEcj7QZgCgMmpnAgQjlwTGKlUkC7hqrao/TcSd0+7erxyOUm8u/qmZBHq 0Exg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771036161; x=1771640961; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; b=wnbdErBMRbbMvDPKqPiHD1Z0qOUSPA30BV8E8tojY5MTF527JMhg00CQx+Mr2FFND7 kfKfFoxaslN7/k0G6stFOW0FMw+BkI98+NkDRF3eHrTfP2E5TCtGr7ZKU0HFlAtys9Nl zNbrZBrBv7DKIb8MfU03ZP8dYH14M5RkPzC7GM9rXEVn7DSKztfo2QqbmacXFlovxUxa EOmd4uXLMUxbivwyf+rTHdEm7645hQpKaZNq6SF3OoB87LXguIqbVR2aQhzqyHpOTOOd +M5Dzx0oYLNaSkfQyV+Icd70aET3wNMfrxxKzqXmlrle0KrshkuBUiwdxvnPFNzq3dug fIlA== 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 1vr5PS-00688W-1q for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 02:29:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vr5PR-00GuiJ-1c for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 02:29:25 +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 1vr5PR-00GuiB-0a for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 02:29:25 +0000 Received: from mail-yx1-xb12f.google.com ([2607:f8b0:4864:20::b12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vr5PO-00000000XXD-1miu for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 02:29:24 +0000 Received: by mail-yx1-xb12f.google.com with SMTP id 956f58d0204a3-649e97f1e99so1486212d50.2 for ; Fri, 13 Feb 2026 18:29:23 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771036161; cv=none; d=google.com; s=arc-20240605; b=UY7blEL+iaEqb/echCLYxOTgXHPoVesQA+9ItOe8cn3yBVxPoLATHvLVyzgQHjrpLZ TpF5MopY+hfxT4GlgOyFwkKycUset+bRnSjySmbLuzFv99etgO0l6Ut5dlvNb8+LuRnE sxaf/HtSxcMmMhHXz+ufQVvGCiGTDtJkq+m1QNUt789uWP3kxNXprBgmLKMEN+DtNwSl 8n82ngwoAEiE4jWF5nDXKm5MOoLnvuGSocR0Uv8N5v3tRFZ8AakZD1yNBG++eDKURWeX B6OnB2W2OuS9AspjUpzB8tX6VCy32ihJOTUZVCekUBXuek5dkzHeehc16WE8PiKfK4/k LKtA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; fh=2DoGC78b0mi8uZ4UY+9ocPF86GSVzeaJWqou/x907js=; b=JBpG2ONIzO/hGp4XG2x/uYqZ6mD8pFvlR1YicypOpcY5VHdhkEIBHQwOWEe43+M0en wVLCB1bho6LefYqnwNAAuR4UGVy/8jkUq/2HBSofv+QnzGISWXQBr1T4KfudRuh++q1H fR1riFEOfH8nnoP32kg3ZtrxFnSMJKilBszA78Dt7Mln70A2AeEaKrPgmy3wptsCoYv4 886DiAPpv/IHmXQG7nm6DlIpMb+BAUfA1Yw5NYJeqZhEne37X8EYuIw9LPw0Vs1gOqkT 4JUo6FXB3FjKGs/Q/DVPQTllE/Sule5IusFLQKMFs+Vaxv+FQ+7sP3EE3Eg40sx6rftT +zNw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771036161; x=1771640961; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; b=GKHG4gFCCGzOfUf5BdNx2rsPETmi5+7Xnk03crCtx/6OmGp6DqK6goXMlCqyFvd04i 71VYdfTMzZoaPScYH+A/FDWVD1k2uyFUzgTg0hVzbOCfhIxtds6orGKHoyHA3vBMvuAp T31tCcVq4EqiRPa2s6ZhA4XzM/+qnSCA3sNMupfvtDAHuLMYCSzTYEMPkmQfZbjFJjQM 5pnAiAz5cdOjAoHXcjpNGkXtPwQQfJBbSKXH0peZtAcQpKY2JD2j98swxyTJrrw5/DjB Y1TxupSTuI6mEcj7QZgCgMmpnAgQjlwTGKlUkC7hqrao/TcSd0+7erxyOUm8u/qmZBHq 0Exg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771036161; x=1771640961; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lGbVSE2ckXay0A5SlDa5FOjRttrjr1mtbeKLSk6RDqI=; b=wnbdErBMRbbMvDPKqPiHD1Z0qOUSPA30BV8E8tojY5MTF527JMhg00CQx+Mr2FFND7 kfKfFoxaslN7/k0G6stFOW0FMw+BkI98+NkDRF3eHrTfP2E5TCtGr7ZKU0HFlAtys9Nl zNbrZBrBv7DKIb8MfU03ZP8dYH14M5RkPzC7GM9rXEVn7DSKztfo2QqbmacXFlovxUxa EOmd4uXLMUxbivwyf+rTHdEm7645hQpKaZNq6SF3OoB87LXguIqbVR2aQhzqyHpOTOOd +M5Dzx0oYLNaSkfQyV+Icd70aET3wNMfrxxKzqXmlrle0KrshkuBUiwdxvnPFNzq3dug fIlA== X-Gm-Message-State: AOJu0YxClXpcm3ciQhWxYZVqekjvsyFmSzA29tzSV+PRIhNWyFiKblDL ojORXSwlT11wWAIiv9Y43bJp0b9RDJTqDcPQH3g2dvZ/KUiybVLlTppT5daWys/3mu2HEDGUjyL AEDgI+C0mLdIpIRf9dUSpHsmvyj7YdFkGdKvg X-Gm-Gg: AZuq6aJK3m/YimGAThgM7miGFUbExo/r6YbQNdWnYypmk+vsoiAD3wMl2Tvy2Xv6tGi EOOxpBzNanY96hxNJ9xhwff3k5Ue8/dnAg0LKYR467Js6/yYNTIhCE24Wzo1sFQs5sP+UbT14gd vbt13n51aZLUFvC2cLw/nCKyKcAxczTL0Z6psPSRvXmxS+D2Lx6v4hpbzLngtaaQdTRijGdl8Z4 xCXIpNFuiF2YOjyV3/xRzzfHIsMhvJKQaZvkKLtSDszFdkUgvh3ZhaxlEgFJuPZwu31CY5NXgKm mDl3rALtmcWHcBUDErdhH49RlscJk2DIrw+Ds2tJMf8gzJUPww== X-Received: by 2002:a05:690e:4146:b0:64a:dafe:fb5 with SMTP id 956f58d0204a3-64c197ae418mr3440665d50.23.1771036161219; Fri, 13 Feb 2026 18:29:21 -0800 (PST) MIME-Version: 1.0 From: Igor Korot Date: Fri, 13 Feb 2026 18:29:11 -0800 X-Gm-Features: AZwV_QirqW8NamaGbbRW4YVoqJVisSjNPodMcFe3i-Rk8XYl_xPVejGta79tGSU Message-ID: Subject: PRIMARY KEY parameters To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Page https://www.postgresql.org/docs/9.1/sql-createtable.html states: [quote] [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK ( expression ) | DEFAULT default_expr | UNIQUE index_parameters | PRIMARY KEY index_parameters | REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [/quote] And then: [quote] index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are: [ WITH ( storage_parameter [= value] [, ... ] ) ] [ USING INDEX TABLESPACE tablespace ] [/quote] How can I retrieve those 2 parameters? Thank you X-Gm-Message-State: AOJu0YxClXpcm3ciQhWxYZVqekjvsyFmSzA29tzSV+PRIhNWyFiKblDL ojORXSwlT11wWAIiv9Y43bJp0b9RDJTqDcPQH3g2dvZ/KUiybVLlTppT5daWys/3mu2HEDGUjyL AEDgI+C0mLdIpIRf9dUSpHsmvyj7YdFkGdKvg X-Gm-Gg: AZuq6aJK3m/YimGAThgM7miGFUbExo/r6YbQNdWnYypmk+vsoiAD3wMl2Tvy2Xv6tGi EOOxpBzNanY96hxNJ9xhwff3k5Ue8/dnAg0LKYR467Js6/yYNTIhCE24Wzo1sFQs5sP+UbT14gd vbt13n51aZLUFvC2cLw/nCKyKcAxczTL0Z6psPSRvXmxS+D2Lx6v4hpbzLngtaaQdTRijGdl8Z4 xCXIpNFuiF2YOjyV3/xRzzfHIsMhvJKQaZvkKLtSDszFdkUgvh3ZhaxlEgFJuPZwu31CY5NXgKm mDl3rALtmcWHcBUDErdhH49RlscJk2DIrw+Ds2tJMf8gzJUPww== X-Received: by 2002:a05:690e:4146:b0:64a:dafe:fb5 with SMTP id 956f58d0204a3-64c197ae418mr3440665d50.23.1771036161219; Fri, 13 Feb 2026 18:29:21 -0800 (PST) MIME-Version: 1.0 From: Igor Korot Date: Fri, 13 Feb 2026 18:29:11 -0800 X-Gm-Features: AZwV_QirqW8NamaGbbRW4YVoqJVisSjNPodMcFe3i-Rk8XYl_xPVejGta79tGSU Message-ID: Subject: PRIMARY KEY parameters To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Page https://www.postgresql.org/docs/9.1/sql-createtable.html states: [quote] [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK ( expression ) | DEFAULT default_expr | UNIQUE index_parameters | PRIMARY KEY index_parameters | REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [/quote] And then: [quote] index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are: [ WITH ( storage_parameter [= value] [, ... ] ) ] [ USING INDEX TABLESPACE tablespace ] [/quote] How can I retrieve those 2 parameters? Thank you