Re: one table from the db on a separate drive

am  15.02.2006, um 11:25:03 +0530 mailte Pradeep Parmar folgendes:
> Hi,
>
> how can i place a table from my db on a separate drive than the whole
> database. I have 2 HDD in my system and my db resides on one of them. i want
> to move a single table from one hdd to another on the same system.
> Is it posible? if yes, how??

You can create a new tablespace and use this. Read
http://www.postgresql.org/docs/8.1/interactive/manage-ag-tablespaces.html


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===