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.


Reply via email to