Windows file path for copy

From: Richard Sydney-Smith <richard(at)ibisau(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Windows file path for copy
Date: 2005-08-03 02:24:43
Message-ID: 42F02AEB.3050204@ibisau.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Windows XP SP2 with Postgresql 8.0.3
Two commands on fails the other succeeds:

Fails :

select import_sharedata('C:\\Documents and
Settings\\Richard\\Desktop\\EzyChart-20050721');

Succeeds:

select import_sharedata('C:\\EzyChart-20050721');

is it the spaces in the path that postgres does not like? If so how do I
format the enquiry pls?

Failure message indicates that It can not access the file. However the
file is downloaded to my destop and thus has been created with my
permissions.

Browse pgsql-general by date

  From Date Subject
Next Message Eric D. Nielsen 2005-08-03 03:12:08 Need some help creating a database sandbox...
Previous Message Tom Lane 2005-08-02 23:03:37 Re: feeding big script to psql