Re: Postgresql On Windows

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
------------------------------------------------------------------