On 06/04/2015 11:35 AM, Emi Lu wrote:
> Hello,
>>
>> to remove tablespace for primary key please?
>>
>> For example, z1 (c1 text) with pk_z1 PRIMARY KEY (c1), tablespace
>> "abc"
>>
>> May I know how to remove tablespace(set tablespace to empty for z1)?
>>
>>
>> It doesn't make sense to "remove" a tablespace...the best you can do
>> is change a table's (and its related indexes) tablespace
>>
>> from one to another.
>>
>> If "ALTER TABLE ... SET TABLESPACE ..." doesn't accomplish your goal
>> you will need to explain yourself better.
>
> Want to SET tablespace = '' for primary key but not table. Tried alter
> index ... set tablespace='', but empty does not work?
set tablespace pg_default
>
> Thanks
>
--
Adrian Klaver
adrian.klaver@aklaver.com