Skip site navigation (1) Skip section navigation (2)

RE: psql /i path?

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: RE: psql /i path?
Date: 2001-08-30 05:16:08
Message-ID: HOEFIONAHHKFEFENBMNOMELKCBAA.rsanford@nolimitsystems.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
if i use either of the following paths
   /cygdrive/c/stuff/fantas~1/develo~1/server/db/tables.sql
   /cygdrive/c/stuff/fantas~1/development/server/db/tables.sql

it works fine. that tells me that /i has problems with
directory names that contain spaces and it isn't just
long filenames.

bug? if so, i'll report it but if it is FAD then i won't.

rjsjr

> -----Original Message-----
> From: Robert J. Sanford, Jr. [mailto:rsanford(at)nolimitsystems(dot)com]
> Sent: Thursday, August 30, 2001 12:13 AM
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: psql /i path?
> 
> 
> in my cygwin bash shell i executed mount which loads
> up all of my drives. i then run psql and try to use
> the /i command to import a sql file. i am getting
> errors such as...
> 
>           -- begin error msgs --
> football=# \i /cygdrive/c/stuff/fantasy 
> football/development/server/db/tables.sql
> 
> /cygdrive/c/stuff/fantasy: No such file or directory
> 
> \i: extra argument 
> 'football/development/server/db/tables.sql' ignored
>           -- end error msgs --
> 
> that tells me that either psql doesn't like using
> my cygdrive mappings or it doesn't like the directory
> name with a space in it.
> 
> i tried surrounding the entire path with "" but i
> get...
> 
>           -- begin error msgs --
> football=# \i "/cygdrive/c/stuff/fantasy 
> football/development/server/db/tables.sql"
> 
> "/cygdrive/c/stuff/fantasy 
> football/development/server/db/tables.sql": No such file or 
> directory
>           -- end error msgs --
> 
> when i am just trying to get to the directory from the
> bash shell and i surround the entire thing with quotes
> it works fine.
> 
> any suggestions?
> 
> rjsjr
> 

In response to

  • psql /i path? at 2001-08-30 05:12:52 from Robert J. Sanford, Jr.

pgsql-cygwin by date

Next:From: S. L.Date: 2001-08-30 05:36:19
Subject: RE: psql /i path?
Previous:From: Robert J. Sanford, Jr.Date: 2001-08-30 05:12:52
Subject: psql /i path?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group