You mean we can have only single default tablespace for a database but the database objects can be created on different-2 tablespaces?
From: amul sul <sulamul@gmail.com> Sent: Friday, February 21, 2020 11:48 AM To: Daulat Ram <Daulat.Ram@exponential.com> Cc: pgsql-general@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database.
Maybe I have misunderstood your question; there is no option to specify more than one tablespace for the database, but you can place the objects of that database to different tablespaces (if options available for that object). E.g. you can place a table in than conn_tbs tablespace.
If option is not specified then by default that object will be created in conn_tbs.