Re: [GENERAL] creating tables in tablespace

2017-08-24 Thread Tom Lane
Tiffany Thang 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 t

Re: [GENERAL] creating tables in tablespace

2017-08-24 Thread Tiffany Thang
Thanks Tom. As the superuser, I'm able to create the table in the specific tablespace. Does myuser require additional privileges? 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 p

Re: [GENERAL] creating tables in tablespace

2017-08-24 Thread Tom Lane
Tiffany Thang writes: > According to the documentation, a table can be created in a specific > tablespace by performing the following: > 1. Specify the tablespace parameter in the create database statement. > 2. Specify the tablespace parameter in the create table statement. > I've tried both but