> Since "tablespace" is not part of the SQL standard, maybe it makes
sense to
> define a more specific syntax. The term "location" makes sense,
because it is
> not a tablespace as Oracle defines it.
It *is* an "OS managed tablespace" in terms of IBM DB2.
Methinks the term "TABLESPACE" is perfect for PostgreSQL.
The fact whether it is a directory, a file or even a raw device
depends on how you create the tablespace.
The point is, that the syntax for "create table" and "create index"
can be compatible in this case, imho without confusing many.
Not the "create tablespace" syntax, but that is imho not an issue.
Andreas