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

From Josh Williams
Subject Re: Reg: Permission error in Windows psql while trying to read sql commands from file
Date
Msg-id 1223835449.9494.6.camel@godzilla.local.scalefeather.com
Whole thread Raw
In response to Re: Reg: Permission error in Windows psql while trying to read sql commands from file  ("Raj K" <raj.indian.08@gmail.com>)
Responses Re: Reg: Permission error in Windows psql while trying to read sql commands from file  ("Raj K" <raj.indian.08@gmail.com>)
List pgsql-general
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: Steve Atkins
Date:
Subject: Re: Run postgresql engine in readonly mode?
Next
From: Sam Mason
Date:
Subject: Re: Need schema design advice