Hi Amul , Please share the examples how we can create no. of tablespaces for a single database and how we can use them. As I know we can create database on tablespace
1. CREATE TABLESPACE conn_tbs OWNER enterprisedb LOCATION '/mnt/pgdatatest/test/pgdata/conn_tbs'; 2. Create database test tablespace ‘conn_tbs'; Can we have multiple tablespaces with in a database in postgres? Yes. From: amul sul <sula...@gmail.com> Sent: Friday, February 21, 2020 11:16 AM To: Daulat Ram <daulat....@exponential.com> Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram <daulat....@exponential.com<mailto:daulat....@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
