Re: creating tables in tablespace

Tiffany Thang <tiffanythang(at)gmail(dot)com> writes:
> Thanks Tom. As the superuser, I'm able to create the table in the specific
> tablespace. Does myuser require additional privileges?

Yes, USAGE on the tablespace if memory serves (check the GRANT man page
for details).

> My aim is to be able to create table in a specific tablespace (in this
> case, mytablespace) by default without having to explicitly specific one. I
> would think that is possible but I'm having trouble making it happen.

Setting default_tablespace, perhaps per-role or per-database if you
don't want to do it within a session, is the way to do that.

regards, tom lane