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

Поиск
Список
Период
Сортировка
От Raj K
Тема Re: Reg: Permission error in Windows psql while trying to read sql commands from file
Дата
Msg-id 6373f61d0810131010r53bceea3g342c9b09e1a3cdc3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reg: Permission error in Windows psql while trying to read sql commands from file  (Josh Williams <joshwilliams@ij.net>)
Список 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 по дате отправления:

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: Re: NATURAL JOINs
Следующее
От: "Richard Broersma"
Дата:
Сообщение: Re: More schema design advice requested