| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Where the info is stored |
| Date: | 2026-02-17 00:38:48 |
| Message-ID: | CA+FnnTwmt7BOqwZnsB5LOq47U+wzRc86wXaea9B0KEXfK2O+Kw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-02-17 00:49:19 | Re: Where the info is stored |
| Previous Message | Igor Korot | 2026-02-17 00:15:23 | Re: Why there is no records? |