Re: Windows file path for copy

Where does import_sharedata() come from? AFAIK, it's not a part of
standard PostgreSQL. PostgreSQL functions for this is COPY, where just
this fact is documented at
http://www.postgresql.org/docs/8.0/static/sql-copy.html, under "Notes".

//Magnus

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
> Richard Sydney-Smith
> Sent: Wednesday, August 03, 2005 6:10 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Windows file path for copy
>
> Thanks. Can see the logic but many users are going to presume
> that they can load from "their" desktop. For now I can
> operate around the issue but will have to place instructions
> in big letters unless I want to answer this adnauseum.
>
>
> Magnus Hagander wrote:
>
> 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.
>
>
>
> I assume import_sharedate() is a server-side function.
> In this case, the
> *service account* needs permissions, not you. And don't
> grant it to your
> desktop - that's generallyi a bad idea :-) Use a shared
> dir somewhere
> that both you and the service accoutn has permissions on.
>
> //Magnus
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send
> an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>
>
>
>