Re: Reg: Permission error in Windows psql while trying to read sql commands from file

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(at)ij(dot)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
>
>
>