Attached.
There is no other way at the moment to get the tablespace name of anobject in psql.
We get information for tables, index, sequences and toast tables.
We should probably do this for schemas too...
Gavin