In PostgreSQL tablespaces and user all cluster level objects. tablespace is just another name for a folder where the Postgres server process owner (typically “postgres” system user) is the owner and can write some files.
In PostgreSQL All objects stored in default tablespace i.e. pg_default.
You can create or alter databases in the tablespace and assign ownership for that tablespace.
On Mon, Jan 14, 2019 at 8:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Hello experts,
From oracle databases, I have few tablespaces and users created for that particular database. How could I do the same for postgres?
thank you.
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)