Skip site navigation (1) Skip section navigation (2)

Move tables to tablespace

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Move tables to tablespace
Date: 2008-10-20 14:10:46
Message-ID: B10E6810AC2A2F4EA7550D072CDE876001D209A6@SAB-FENWICK.sab.uiuc.edu (view raw or flat)
Thread:
Lists: pgsql-admin
I would like to have an SQL statement that would move all of the tables
and indexes found within a particular schema to a particular tablespace.
Is there a way I can do this?

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu <http://webservices.uiuc.edu/> 

 

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-10-20 16:44:39
Subject: Re: 32bit data on 64bit machine?
Previous:From: Simon RiggsDate: 2008-10-20 13:54:31
Subject: Re: Strategies for validating WAL-shipping replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group