Windows file path for copy - Mailing list pgsql-general

From Richard Sydney-Smith
Subject Windows file path for copy
Date
Msg-id 42F02AEB.3050204@ibisau.com
Whole thread Raw
List 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: feeding big script to psql
Next
From: "Eric D. Nielsen"
Date:
Subject: Need some help creating a database sandbox...