Re: BUG #15901: Tablespace showing as null in psql and pgadmin

Hi Tom,

Thanks for clarification but this should be part of functionality. It should show the non default tablespace if any. This is like tightly coupled as postgres do not want to user to use other than default tablespace.

In my application, tablespace is requires to collect information for table. I have tried the other ways to extract it but I am failed to extract it.

can you please help , How we can extract the details of User defined tablespace for the table created under it.

Thanks & Regards,
ISHAN JOSHI

________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Tuesday, July 9, 2019 8:09 PM
To: ishanjoshi(at)live(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15901: Tablespace showing as null in psql and pgadmin

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> As I have created separate tablespace (Not using default tablespace
> pg_default or pg_global) for my new database. I have tried to create tables
> with and without tablespace parameter and both these tables while checking
> in pg_table, tablespace column showing as null. I tried to extract from
> other tables but getting tablespace as null only.

The case you showed isn't a bug: creating a table that's specified to be
in the database's default tablespace is treated the same as not specifying
any tablespace. This is because if you change the database's default
tablespace later, such a table will be moved along with every other table
that's in the database's default tablespace.

regards, tom lane