Re: Tablespaces

Thanks for the advice guys. I've seemed to get it working now. It'd
like to provide an explanation as to how, but I've tried so many
things that I'm a bit lost.... but all is working fine now! Thanks
again.

On 24 September 2013 12:40, Luca Ferrari <fluca1978@infinito.it> wrote:
> On Mon, Sep 23, 2013 at 5:50 PM, James David Smith
> <james.david.smith@gmail.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