Tim Kane wrote > The documentation describes the tablespace parameter as: > The name of the tablespace that will be associated with the new database, > or > DEFAULT to use the template database's tablespace. This tablespace will be > the default tablespace used for objects created in this database. See > CREATE > TABLESPACE > <http://www.postgresql.org/docs/9.3/static/sql-createtablespace.html> > for > more information. > > Is this a documentation issue, or a behavioural one? It isn't clear to > me. The operative sentence is: "This tablespace will be the default tablespace used for [new] objects created in this database." The implied "new" (inserted because of the word "default" preceding) means that any existing objects in the template database will be assigned the same tablespace onto which they are currently attached. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/CREATE-DATABASE-TEMPLATE-template-TABLESPACE-tablespace-name-tp5772451p5772464.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general