Postgres Pro
Downloads
Home   >   mailing lists

RE: Can we have multiple tablespaces with in a database. - Mailing list pgsql-general

From Daulat Ram
Subject RE: Can we have multiple tablespaces with in a database.
Date
Msg-id MN2PR01MB5854A3B7B8A627544C5398E49B120@MN2PR01MB5854.prod.exchangelabs.com
Whole thread Raw
In response to Re: Can we have multiple tablespaces with in a database.  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Can we have multiple tablespaces with in a database.  (amul sul <sulamul@gmail.com>)
List pgsql-general
Tree view 
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/schemacreation.  

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



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

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@thebuild.com

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Can we have multiple tablespaces with in a database.
Next
From: stan
Date:
Subject: How to get the name of the table taht fired a triigger?