Postgres Pro
Downloads
Home   >   mailing lists

Re: null tablespace? - Mailing list pgsql-general

From Raghavendra
Subject Re: null tablespace?
Date
Msg-id CA+h6AhhfH91BWZGUXWZOE+k=_FYxY+3esce3Bh-bVEnhDgX45g@mail.gmail.com
Whole thread Raw
In response to Re: null tablespace?  (Tony Capobianco <tcapobianco@prospectiv.com>)
List pgsql-general
Tree view

On Fri, Dec 16, 2011 at 2:07 AM, Tony Capobianco <tcapobianco@prospectiv.com> wrote:
Awesome!  We had about 200G worth of tables on our mount point that held
all our WAL data....whoops!  Thanks for the below query.

One last question, can I define a default tablespace per schema?  I
haven't found anything by searching around.

Thanks.
Tony


You can do it at user-level not with schema-level directly. I mean, assign a tablespace to user first and then assign schema to that user. 

---
Regards,
Raghavendra
EnterpriseDB Corporation


pgsql-general by date:

Previous
From: Tony Capobianco
Date:
Subject: Re: null tablespace?
Next
From: Xiaobo Gu
Date:
Subject: Re: question about \encoding option of psql