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@xxxxxxxxx> wrote: > From: John Cheng <jlcheng@xxxxxxxxx> > Subject: Re: Postgresql On Windows > To: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxx> > To: MDB <mdb002@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Sent: Friday, March 27, 2009 7:35:47 AM > Subject: Re: 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@xxxxxx > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
