Re: Tablespaces

On Mon, Sep 23, 2013 at 5:50 PM, James David Smith
<james(dot)david(dot)smith(at)gmail(dot)com> wrote:

> SELECT relname FROM pg_tablespace;
>

Uh? There is no relname in pg_tablespace:
http://www.postgresql.org/docs/current/static/catalog-pg-tablespace.html

> But when they run a command such as this, the new database is still
> made in the default directory, rather than the persona folder:
>
> CREATE DATABASE testing(i int)
>
> Would appreciate any thoughts and guidance please. The aim is to keep
> everyone's work in their own folders.

According to the documentation
(http://www.postgresql.org/docs/9.2/static/runtime-config-client.html)
if the tablespace name does not match any existing table space
PostgreSQL will default to default (i.e., will create objects in the
default tablespace). Moreover: "This variable is also not used when
creating databases. By default, a new database inherits its tablespace
setting from the template database it is copied from."

Luca