Re: Postgresql On Windows

Thank you,

I also found you could drop the "C:" (e.g. "/sql/test.sql") if it is on the c drive. The backslashes on my system threw the same error..

--- On Fri, 3/27/09, John Cheng <jlcheng(at)ymail(dot)com> wrote:

> From: John Cheng <jlcheng(at)ymail(dot)com>
> Subject: Re: [GENERAL] Postgresql On Windows
> To: pgsql-general(at)postgresql(dot)org
> Date: Friday, March 27, 2009, 12:16 PM
>
> From my experience, you must use the forward slash. Using
> the backslash may give you an error:
>
> \i C:\sql\test.sql
> C:: Permission denied
>
> Instead, use
>
> \i C:/sql/test.sql
>
> ________________________________
> From: Raymond O'Donnell <rod(at)iol(dot)ie>
> To: MDB <mdb002(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Sent: Friday, March 27, 2009 7:35:47 AM
> Subject: Re: [GENERAL] Postgresql On Windows
>
> On 27/03/2009 14:28, MDB wrote:
> > What is the path format for the i (\i) command in the
> SQL shell?
>
> I think it's just as anywhere else on Windows, e.g.
>
>     \i c:\path\to\file.sql
>
> If there are spaces in the path you may have to enclose it
> in double-quotes:
>
>     \i "c:\path with spaces\file.sql"
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral,
> Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>      
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>