On 2013-10-30 06:32, Tim Kane wrote:
Hi all,
I've been looking for a facility to specify the tablespace of an index
that is implicitly created when adding a PK constraint. It turns out
that this does indeed exist, though I could find no mention of it in
the documentation.
ALTER TABLE {table} ADD CONSTRAINT {constraint} PRIMARY KEY
({column(s)} USING INDEX TABLESPACE {tablespace}
The only mention I could find is in reference to the original patch
that implemented this feature.
http://www.postgresql.org/message-id/41072747.8030...@familyhealth.com.au
I'm glad to see it's there, but I wonder if this should be documented?
Tim
This is indicated in the "CREATE TABLE" documentation (to which much of
the "ALTER TABLE" documentation defers).
