Re: Tablespaces oddity?

Philip Yarra <philip@utiba.com> writes:
> Someone else might be able to see a better way to write this query, but I 
> think it would be good if \d could show this information, when you really 
> want to know which tablespace an object is on. 

If \d doesn't say anything then the table is in the database's default
tablespace.  I see nothing wrong with that, and I do object to
cluttering \d output with information that will be of no interest to
people not using tablespaces.

> Note also that \l won't show you the tablespace for a DB, so you need
> to query pg_database to even know which is the default tablespace for
> a DB.

I wouldn't object to adding default tablespace to \l output, or maybe \l+.
        regards, tom lane