MIME-Version: 1.0
References: <CA+FnnTwQaGb6RPddObHQSd7UW37cUJOzXVETfDw+jeyaRFbr6w@mail.gmail.com>
In-Reply-To: <CA+FnnTwQaGb6RPddObHQSd7UW37cUJOzXVETfDw+jeyaRFbr6w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 13 Feb 2026 20:04:15 -0700
Message-ID: <CAKFQuwbYwcS8uZ7bF6gJRhB52fa=nH_EZ_Cthj1twHZF5EzzMQ@mail.gmail.com>
Subject: Re: PRIMARY KEY parameters
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000038bcd0064abffc8f"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbYwcS8uZ7bF6gJRhB52fa%3DnH_EZ_Cthj1twHZF5EzzMQ%40mail.gmail.com>
Precedence: bulk

--00000000000038bcd0064abffc8f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 13, 2026 at 7:29=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wro=
te:

> index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:
>
> [ WITH ( storage_parameter [=3D value] [, ... ] ) ]
> [ USING INDEX TABLESPACE tablespace ]
> [/quote]
>
> How can I retrieve those 2 parameters?
>
>
You'd have to look at the tablespace and storage parameters of the index in
question, it isn't a property of the table.  The indexes are immediately
created with those attributes.

David J.

--00000000000038bcd0064abffc8f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Feb 13, 2026 at 7:29=E2=80=AFPM Igor Korot &lt;<a =
href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</a>&gt; wrote:</span>=
</div></div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">index_parameters in UNIQUE, PRIMARY KEY=
, and EXCLUDE constraints are:<br>
<br>
[ WITH ( storage_parameter [=3D value] [, ... ] ) ]<br>
[ USING INDEX TABLESPACE tablespace ]<br>
[/quote]<br>
<br>
How can I retrieve those 2 parameters?<br><br></blockquote><div><br></div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
">You&#39;d have to look at the tablespace and storage parameters of the in=
dex in question, it isn&#39;t a property of the table.=C2=A0 The indexes ar=
e immediately created with those attributes.</div><div class=3D"gmail_defau=
lt" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><br></div></div></div>

--00000000000038bcd0064abffc8f--