Home > mailing lists

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

From	amul sul
Subject	Re: Can we have multiple tablespaces with in a database.
Date	February 21, 2020 05:46:27
Msg-id	CAAJ_b954ug=jYDvNUsnHj3j7yGt_p_nN31C7yDA8eafmOBcGOw@mail.gmail.com Whole thread Raw
In response to	Can we have multiple tablespaces with in a database. (Daulat Ram <Daulat.Ram@exponential.com>)
Responses	RE: Can we have multiple tablespaces with in a database. RE: Can we have multiple tablespaces with in a database.
List	pgsql-general

On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram <Daulat.Ram@exponential.com> wrote:

Hi Team,

Can we have multiple tablespaces with in a database in postgres?

Yes.

Can we have a table on different tablespace same as Oracle?

Yes -- specify TABLESPACE option while creating that table.

Regards,

Amul

From: Daulat Ram
Date: 21 February 2020, 05:34:21
Subject: Can we have multiple tablespaces with in a database.

From: "David G. Johnston"
Date: 21 February 2020, 05:46:55
Subject: Re: Can we have multiple tablespaces with in a database.