Re: PRIMARY KEY parameters - Mailing list pgsql-general

From David G. Johnston
Subject Re: PRIMARY KEY parameters
Date
Msg-id CAKFQuwbYwcS8uZ7bF6gJRhB52fa=nH_EZ_Cthj1twHZF5EzzMQ@mail.gmail.com
Whole thread
In response to PRIMARY KEY parameters  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
On Fri, Feb 13, 2026 at 7:29 PM Igor Korot <ikorot01@gmail.com> wrote:
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?


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.

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: PRIMARY KEY parameters
Next
From: yudhi s
Date:
Subject: Question on execution plan and suitable index