remove tablespace for primary key (*not* by drop/recreate constraint) - Mailing list pgsql-sql

From Emi Lu
Subject remove tablespace for primary key (*not* by drop/recreate constraint)
Date
Msg-id 55707FAA.8060204@encs.concordia.ca
Whole thread Raw
Responses Re: remove tablespace for primary key (*not* by drop/recreate constraint)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Hello list,

Due to there are lots of foreign key dependencies, would prefer not to 
drop/create for primary key. Is there other way(s) for psql8.3 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)?

Thanks a lot!




pgsql-sql by date:

Previous
From: Skylar Thompson
Date:
Subject: Re: PG and Temporal
Next
From: "David G. Johnston"
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)