Re: Postgresql On Windows - Mailing list pgsql-general

From Dhaval Jaiswal
Subject Re: Postgresql On Windows
Date
Msg-id 805521.88515.qm@web111214.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: Postgresql On Windows  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
 
>>     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@iol.ie>
To: MDB <mdb002@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Friday, March 27, 2009 8:05:47 PM
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

pgsql-general by date:

Previous
From: Dhaval Jaiswal
Date:
Subject: Re: Determining PUBLIC's permissions
Next
From: Scott Marlowe
Date:
Subject: Re: metadata development