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
thesame error..
--- On Fri, 3/27/09, John Cheng <jlcheng@ymail.com> wrote:
> From: John Cheng <jlcheng@ymail.com>
> Subject: Re: [GENERAL] Postgresql On Windows
> To: pgsql-general@postgresql.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@iol.ie>
> To: MDB <mdb002@yahoo.com>
> Cc: pgsql-general@postgresql.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@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
