remove tablespace for primary key (*not* by drop/recreate constraint)

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: remove tablespace for primary key (*not* by drop/recreate constraint)
Date: 2015-06-04 16:41:14
Message-ID: 55707FAA.8060204@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2015-06-04 17:44:38 Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Previous Message Skylar Thompson 2015-06-02 13:36:05 Re: PG and Temporal