Re: Can we have multiple tablespaces with in a database.

From: amul sul <sulamul(at)gmail(dot)com>
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Can we have multiple tablespaces with in a database.
Date: 2020-02-21 11:50:39
Message-ID: CAAJ_b962qbw2OPR0=g1NhuTSJPWdOtn-t7GCrNqTbHz9ReFsqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Fri, Feb 21, 2020 at 12:48 PM Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
wrote:

> What are the differences between Oracle and Postgres tablespace.
>
> I hope this[1] wiki page will help you.

> Can we assign tablespace during Postgres schema creation . As I know in
> Oracle we assign the tablespace during user/schema creation.
>
AFAIK, there is no syntax to assign tablespace to a schema.

Regards,
Amul

1] https://wiki.postgresql.org/wiki/PostgreSQL_for_Oracle_DBAs

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-02-21 14:27:08 Re: How to get the name of the table taht fired a triigger?
Previous Message Luís Roberto Weck 2020-02-21 11:16:29 Parallel Append Query

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick FICHE 2020-02-21 16:24:28 RE: Can we have multiple tablespaces with in a database.
Previous Message Daulat Ram 2020-02-21 07:17:50 RE: Can we have multiple tablespaces with in a database.