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