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\";

Rejean

pgsql-general@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 11/20/06, Tino Wildenhain <tino@wildenhain.de> wrote:
>
> You'll need to write 'D:\\tablespace\\data\\'
> because \ is a apecial char in strings.
>

Or you can use forward slashes as in:

'D:/tablespace/data/'

Regards,

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com