Tiffany Thang <tiffanythang@xxxxxxxxx> 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 the tablespace column in pg_tables is empty. An empty entry in pg_tables means the table is in the database's default tablespace, whether you made it that way implicitly or explicitly. So this looks as-expected to me. You'd need to spread the database across more than one tablespace to get anything in that column. > "show default_tablespace" is also empty. If you didn't do anything to change that setting, that would also be expected. Again, the interpretation is "use the database's default tablespace". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
