Thread: Can't Create Tablespace On Windows 2003
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
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
On 11/20/06, Tino Wildenhain <tino@wildenhain.de> wrote:
Or you can use forward slashes as in:
'D:/tablespace/data/'
Regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com
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