am Mon, dem 26.05.2008, um 12:10:07 -0500 mailte Campbell, Lance folgendes: > Once I have assigned tables and indexes to a particular tablespace that > points to a particular location on disk is there a simple way to move > the files to a new location? > > Example: > Table xyz is using tablespace xyz_tbl which is located at > /somedir/xyz_tbl on the disk. If I want to move it to a new disk > located at /someotherdir/xyz_tbl/ how can I do that easily? ALTER TABLE SET TABLESPACE http://www.postgresql.org/docs/8.3/static/sql-altertable.html PS.: please no top-posting. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
