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

From: Josh Williams <joshwilliams(at)ij(dot)net>
To: Raj K <raj(dot)indian(dot)08(at)gmail(dot)com>
Cc: rod(at)iol(dot)ie, pgsql-general(at)postgresql(dot)org
Subject: Re: Reg: Permission error in Windows psql while trying to read sql commands from file
Date: 2008-10-12 18:17:29
Message-ID: 1223835449.9494.6.camel@godzilla.local.scalefeather.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-10-12 19:12:40 Re: Need schema design advice
Previous Message Steve Atkins 2008-10-12 17:30:06 Re: Run postgresql engine in readonly mode?