Hi all!
PG by default always creates the primary key in the default tablespace unless you specify it to use an index that is defined in a user-defined tablespace.
We can create indexes in user-defined tablespaces, why can't we create a primary key in a user-defined tablespace without having to associate it with an index? Something like:
ALTER TABLE myschema.mytable ADD PRIMARY KEY (akey)
tablespace mytablespace;
Regards,
Michael Vitale