On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote: > > > > > > On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm running out of space on one of my partitions and I still > > have not > > gotten all the data loaded yet. I've read that one could > > symlink the > > pg_pg_xlog directory to another drive. I'm wondering if I can > > do the > > same for specific tables as well. > > > > > > Create another tablespace to the new location and the ALTER TABLE ... > > TABLESPACE newtablespace. > > > > OOooohhh... I didn't know one could use tablespaces like that. (I mean, > I did read the docs, but it just didn't register that it _can_ do > something like that) > > additional question.. do I need to change the search_path?
No (changing tablespaces does not change your logical schema). Regards MP
