RE: psql /i path?

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@nolimitsystems.com]
> Sent: Thursday, August 30, 2001 12:13 AM
> To: pgsql-cygwin@postgresql.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
>