Re: Can't Create Tablespace On Windows 2003

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Rejean Proulx <rejean(at)interfree(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't Create Tablespace On Windows 2003
Date: 2006-11-19 22:04:13
Message-ID: 4560D4DD.7060601@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rejean Proulx schrieb:
> I am running Postgresql 8.1. I can't get the following create statement
> to work. It failes on Column 39 which is my directory name.
>
> CREATE TABLESPACE xxxxxxxxxx LOCATION "D:\tablespace\data\";

I'm pretty sure the " " are wrong. Strings are quotet with
' ' instead. You'll need to write 'D:\\tablespace\\data\\'
because \ is a apecial char in strings.

Regards
Tino

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dananrg 2006-11-19 22:05:02 Druid for postgreSQL - can I export my ERD to MS Access?
Previous Message Rejean Proulx 2006-11-19 20:58:55 Can't Create Tablespace On Windows 2003