Move tables to tablespace - Mailing list pgsql-admin

From Campbell, Lance
Subject Move tables to tablespace
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE876001D209A6@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: Move tables to tablespace  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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

 

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Strategies for validating WAL-shipping replication
Next
From: "Kevin Grittner"
Date:
Subject: Re: 32bit data on 64bit machine?