Re: Changing default tablespace for specific users -- Is it possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Arnold, Sandra" <ArnoldS@xxxxxxxx> wrote:
 
> Coming from the Oracle world we were able to have a different
> default tablespace for each user or for a group of users.  Can you
> set the default tablespace to be different for a group
> users/schemas in PostgreSQL?
 
ALTER ROLE xxx SET default_tablespace = yyy;
 
http://www.postgresql.org/docs/current/interactive/sql-alterrole.html
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux