Where as in Oracle a database can have multiple tablespaces in
postgresql they can have only one, but different databases can
each have
a separate tablespace or storage location. A lot better than
MySql or
Sql*Server, but not quite the same as Oracle.

Why a lot better than SQLServer? SQLServer has supported multiple
datafiles per database in separate locations for ages - at least since
sql 2000. Or am I missing something?