Postgres Pro
Downloads
Home   >   mailing lists

default tablespaces - Mailing list pgsql-general

From Jaime Casanova
Subject default tablespaces
Date
Msg-id c2d9e70e05070509584c011bd8@mail.gmail.com
Whole thread Raw
Responses double entries into database when using IE
List pgsql-general
Tree view 
Hi all,

is there a way to specify a default tablespace for tables and a
different one for indexes without put it in the CREATE statement?

i guess one way is to set 'default_tablespace'  for table's tablespace
create or table without any indexes and then set it for idx's
tablespace and create all indexes, a workaround that come to my mind.

Any other idea?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regex escape [ character and change text result into integer
Next
From: David Pratt
Date:
Subject: Re: Regex escape [ character and change text result into