Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't Create Tablespace On Windows 2003 - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Can't Create Tablespace On Windows 2003
Date
Msg-id 4560D4DD.7060601@wildenhain.de
Whole thread Raw
In response to Can't Create Tablespace On Windows 2003  (Rejean Proulx <rejean@interfree.ca>)
Responses Re: Can't Create Tablespace On Windows 2003  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rejean Proulx
Date:
Subject: Can't Create Tablespace On Windows 2003
Next
From: Alvaro Herrera
Date:
Subject: Re: phpPgAdmin, cannot connect to server