PRIMARY KEY parameters - Mailing list pgsql-general

From Igor Korot
Subject PRIMARY KEY parameters
Date
Msg-id CA+FnnTwQaGb6RPddObHQSd7UW37cUJOzXVETfDw+jeyaRFbr6w@mail.gmail.com
Whole thread Raw
Responses Re: PRIMARY KEY parameters
List pgsql-general
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



pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Fillfactor effectiveness on existing table
Next
From: "David G. Johnston"
Date:
Subject: Re: PRIMARY KEY parameters