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 1vs98e-00813D-1k for pgsql-general@arkaria.postgresql.org; Tue, 17 Feb 2026 00:40:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vs98d-006zLZ-1C for pgsql-general@arkaria.postgresql.org; Tue, 17 Feb 2026 00:40:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vs97H-006vwB-1Z for pgsql-general@lists.postgresql.org; Tue, 17 Feb 2026 00:39:03 +0000 Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vs97F-000000016pa-1N9b for pgsql-general@lists.postgresql.org; Tue, 17 Feb 2026 00:39:03 +0000 Received: by mail-yx1-xb135.google.com with SMTP id 956f58d0204a3-64ada2c30a1so3353289d50.0 for ; Mon, 16 Feb 2026 16:39:00 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771288739; cv=none; d=google.com; s=arc-20240605; b=Vsu61tn90/4cEirSZ65KmFip8cchTDctDxsHWPhfhhYbo40KV10rkQQw585vJnfwTq KBw5lnECeIZZzMRutaRxd3hJuvXINBY7HH4VXLEl1DQUZqiGdav8GtFIjEoTNy8Wu7Xb Kkpxz8tIf7eMKvQyZqSe8P4LjjuolcBGb3o/Zl9pYDTN79y8nP9/hXj5ycU2mGVzxRaP Ny5vJ3788IbbIs+rAIkditgODiY1DeO723/Yw9rTBQxvZt0fRTBj5hg9hGJt2F8J/GNi ThLQ6Bi13cxGnhR9ZfzBu04ogIuAwt/aQbqXzLy1hnP1ij479QunFBXf9IMYYtOdAiZ3 9RGQ== 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=bNUxwi/LrzgOAEyNC8Gp1+dKHXuwF6wmXhKUjISEm/o=; fh=2DoGC78b0mi8uZ4UY+9ocPF86GSVzeaJWqou/x907js=; b=C12Gg9yTNTslZBII1MmMI+lDD83LJTFyiti3wN+yuXwP6ND46oxnFJk0A68xTqNEis +ZUCejP3FX/s4ai3rneWl+0z1YlD5VvjzYoBWsOZewMhsopVBU47OzhZ1il+hgKkq4n4 Pm78pXgNlvtReMMvr9a58cbP6Xp+gkNkCS8Plen4KOmRZe3ZlGdnYhWe2tfkEjs31YPg 01QFoQwJMCXmgzxGQ0mLYHJqwR1MspkFJASXTVBZAxgx1UrMegMLtopgHVgCBfsoMaV2 XOomuOFcNp+JwtcgJKSO0Okx/Z3vAA3OLypveF3G7f4eNp4w2OrRQy12z13/HsOReHYT 4MDg==; 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=1771288739; x=1771893539; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=bNUxwi/LrzgOAEyNC8Gp1+dKHXuwF6wmXhKUjISEm/o=; b=R1RXcJfJAY/kqpRVsqlbMExAitW+FNJ2v4GP0jySi2Kd7mbthAGgNstgC6g++UppLA HPWO6pGlXi8+rp+0uMKnZ22l4C365JeLg67GRgGiO8uTxY06Q10pGgKV9sWdRpw6LKfy Oq+a2WTWYxADUA6n4AbCQEt0tXVMkfsj00IEauvODIFnnJcE/XF/8r8u8dNuus4vYCcv QtmJaoUgiYXltRU6Le/+jxhvTxbtCdKJz2XlJK+yklFQlT3hplgqYpigW1MYBmjeyIOV FF0gU94fg6CQEnq1/TCWdop6DCVxbMd/Xnl9a6MquGclaYSDPnzoHGbOl1V+j9vcNv1t GgEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771288739; x=1771893539; 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=bNUxwi/LrzgOAEyNC8Gp1+dKHXuwF6wmXhKUjISEm/o=; b=bzrcnvbrgVX8mk+ZLQP2//z6OtTUp1yVkf+Ya5FCjBSdv3Pn3NYVTsJp49xkxTiRqw VKzyS+raW4h4RV3eja1/agxSu7tNrJwRqHAMFO/QoqeQsceNscJn2BLOLp0kPQwdAe8h GNLuZtM8jRpZd4CsTZDxJm0A7NLJs+9sLVOvImY6yPpYOUm7JPR/iZ2Jkw773XlJcn5B VyE/iTm6IO8IfXMepMBbI9MxEpcfwkyNHV0h3EEu0GzcD+oep5P+5g1T6mFTpFjBGsDN b9PXO4vd64CK/GqLgNMZtiY9OUqogDkmqEYBAtzip1hPkJVmJkXbMFO3OmfphwJtFyRE kDQg== X-Gm-Message-State: AOJu0Yzl+sazzm/Aqo8z5rE8J/FW4wvGi37ilp3Sa1zTkpIeNDDK6gbG iu1UcIGZyUZUy1O1Me+wbwvEkUHq+jU7TrtLvdJV9zfvA/59JEmLRB+13VMBd2nU9YULm2P+MAs hWrpwCF7edWu+uP4ozC9iFkk617/nQEsxEswyvBM= X-Gm-Gg: AZuq6aL5t1XHBiijKUt+IaqpN6PYnL/AgKYYNgVI3qSji85qMSX+Uaf29F55eWglfTH XKz1pJSZv0py7k9wWnASP80045Bmvock/TyOEkHp//GV6PmlPqPgbX84tp+bqgcfROyQ04QTyQ1 dAY7/ajQEgPsmiAyz+VK+1EvW0nEllXyMwkOoz+1ibA/YrWYCXE7rive8H6CZMlhKL15/8bGWht oWpr3VLyW1RPPPFQZ9y1T9ls+sI2/uV9oKPfAF2qKHNgYA2CjnPZJ2VO9W80BteBPNLgdg+nxjB BxZrpNh3FRt1kQtJOrAs/w== X-Received: by 2002:a05:690e:1349:b0:649:bb4b:f822 with SMTP id 956f58d0204a3-64c19b2cd5bmr9378058d50.48.1771288739288; Mon, 16 Feb 2026 16:38:59 -0800 (PST) MIME-Version: 1.0 From: Igor Korot Date: Mon, 16 Feb 2026 18:38:48 -0600 X-Gm-Features: AZwV_QhyIMmw4Uc57Lk4JySwpEacwLPZUgT5Srq1tNkIff7gcauzTkhGwiEuKP0 Message-ID: Subject: Where the info is stored 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, ALL, The page at https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS says: [quote] index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are: [ INCLUDE ( column_name [, ... ] ) ] [ WITH ( storage_parameter [= value] [, ... ] ) ] [ USING INDEX TABLESPACE tablespace_name ] [/quote] Where are included columns and storage_parameters located? I already figured out how to get the tablespace: draft=# SELECT n.nspname FROM pg_constraint c, pg_namespace n, pg_class cl WHERE connamespace = n.oid AND contype = 'p' AND cl.oid = conrelid AND cl.relname = 'leagues'; But now I need the other 2 clauses. Thank you.