From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Tiffany Thang <tiffanythang(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: creating tables in tablespace |
Date: | 2017-08-24 18:46:08 |
Message-ID: | 7180.1503600368@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tiffany Thang <tiffanythang(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tiffany Thang | 2017-08-24 18:57:25 | Re: creating tables in tablespace |
Previous Message | Tiffany Thang | 2017-08-24 18:31:33 | creating tables in tablespace |