Re: Tablespaces for indexes, tables and databases

Erwin Brandstetter wrote:
> (...) (tablespace of the database / default_tablespace / pg_default -- 
> whichever comes first).

Just for the record: actually this should read:  (default_tablespace / 
tablespace of the database) -- whichever comes first.
If the parameter "default_tablespace" is set, it is used.
If not, the tablespace of the database is used (which defaults to the 
tablespace of template at creation time,  which, in turn, defaults to 
"pg_default").

But I assume you got that right anyway.


Regards
Erwin