Обсуждение: 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

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
>

[...]

>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 --
[...]
Replace " (double quotes) with ' (single quotes) and you're ok.

SLao


__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with
Shop@Netscape!http://shopnow.netscape.com/ 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/