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 <x...@thebuild.com> Sent: Friday, February 21, 2020 12:07 PM To: Daulat Ram <daulat....@exponential.com> Cc: amul sul <sula...@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....@exponential.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 x...@thebuild.com
