Alex Williams schrieb am 15.07.2019 um 20:35:
But in my case, I have a database that's in a user-defined tablespace
(data2) and all the tables/indexes there are also in data2 and I want
to do a select into a table the results of all the tables /
tablespaces they are in that database...when doing this:
SELECT distinct tablespace FROM pg_tables;
I get 2 rows: null and pg_global (I think to expect null for
pg_default, but if the table is in a user-defined tablespace, should
we expect it to show it, in my case, data2?)
If data2 is the default tablespace of the database, then this is expected.
The tablespace column is null in pg_tables if the table is located in the
default tablespace of the database.
See here:
https://www.postgresql.org/message-id/flat/15901-e5cfe2dd7298a3a4%40postgresql.org
And the answer on SO:
https://stackoverflow.com/a/56950950
Thomas
