>> postgres=# \i C:/dj1.sql;
>> If there are space.
------------------
postgres=# \i 'C:/Program Files/PostgreSQL/8.3/bin/dj.sql';
Thanks & Regards
Dhaval Jaiswal
From: Raymond O'Donnell <rod@xxxxxx>
To: MDB <mdb002@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Sent: Friday, March 27, 2009 8:05:47 PM
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
