Re: Reg: Permission error in Windows psql while trying to read sql commands from file - Mailing list pgsql-general

From Raj K
Subject Re: Reg: Permission error in Windows psql while trying to read sql commands from file
Date
Msg-id 6373f61d0810131010r53bceea3g342c9b09e1a3cdc3@mail.gmail.com
Whole thread Raw
In response to Re: Reg: Permission error in Windows psql while trying to read sql commands from file  (Josh Williams <joshwilliams@ij.net>)
List pgsql-general
Thank you very much, Josh.
This worked. The backward slashes were the problem.
I had tried the quote part earlier, but even that did not work because of the backward slashes.

Is there somewhere I can document this for other newbies facing the same issue?

Again, thank you very much.

On Sun, Oct 12, 2008 at 11:47 PM, Josh Williams <joshwilliams@ij.net> wrote:
On Sun, 2008-10-12 at 09:25 +0530, Raj K wrote:
> Since it is in windows - I could not find any specific file permission
> mechanisms similar to linux. (This is my first foray in windows - so I
> am a newbie there too )
> The computer is not in a network. So, through googling, I found that
> to share it, we have to move it to
> C:\Documents and Settings\All Users\Documents\ - which I did.
>
> But even that did not help - as mentioned in the first mail.

Try using forward slashes in your path:
testdb=# \i c:/testdb.txt

And if you have spaces, enclose the path in quotation marks:
# \i 'C:/Documents and Settings/All Users/Documents/DB/testdb.txt'


> If you could help me on this I would be much obliged..
>
> Regards
> Raj

- Josh Williams



pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: NATURAL JOINs
Next
From: "Richard Broersma"
Date:
Subject: Re: More schema design advice requested