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

What are the differences between Oracle and Postgres tablespace.

Can we assign tablespace during Postgres schema creation . As I know in Oracle we assign the tablespace during user/schema creation.

-----Original Message-----
From: Christophe Pettus <xof(at)thebuild(dot)com>
Sent: Friday, February 21, 2020 12:07 PM
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
Cc: amul sul <sulamul(at)gmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Can we have multiple tablespaces with in a database.

> On Feb 20, 2020, at 22:34, Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> wrote:
>
> You mean we can have only single default tablespace for a database but the database objects can be created on different-2 tablespaces?

Yes.

> Can you please share the Doc URL for your suggestions given in trail mail.

https://www.postgresql.org/docs/current/manage-ag-tablespaces.html

--
-- Christophe Pettus
xof(at)thebuild(dot)com