Philip Yarra <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings