Hello,

I am running the windows version of PostgreSQL 8.1 on my XP laptop. I
was trying the \cd command to change working directories [to import
query files to run] to the Documents and Settings directory (eventually
to the desktop) and I am getting an error where psql doesn't recognize
the gap between Documents and Settings.

The error states,

\cd : could not change directory to "C:/Documents": No such file or
directory.

Does anyone have any solutions on how to get around this issue with the
Documents and Settings directory?

Thank you in advance!

Casey Crosbie

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Andrej,

Thanks for the suggestion. As you said, I tried enclosing "Documents and
Setting" and even "C:/Documents and Settings" and neither worked. Please
let me know if you have any other ideas.

Thanks,

Casey

Andrej Ricnik-Bay wrote:
> On 7/2/07, Casey Crosbie <casey.crosbie@noaa.gov> wrote:
>> Hello,
>>
>> I am running the windows version of PostgreSQL 8.1 on my XP laptop. I
>> was trying the \cd command to change working directories [to import
>> query files to run] to the Documents and Settings directory (eventually
>> to the desktop) and I am getting an error where psql doesn't recognize
>> the gap between Documents and Settings.
>>
>> The error states,
>>
>> \cd : could not change directory to "C:/Documents": No such file or
>> directory.
>>
>> Does anyone have any solutions on how to get around this issue with the
>> Documents and Settings directory?
> Try enclosing Documents and Settings in quotes ...
> "Documents and Settings"
>
>> Thank you in advance!
>
>> Casey Crosbie
> Cheers,
> Andrej
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On Sunday 01 July 2007 21:51:08 Casey Crosbie wrote:
> Andrej,
>
> Thanks for the suggestion. As you said, I tried enclosing "Documents and
> Setting" and even "C:/Documents and Settings" and neither worked. Please
> let me know if you have any other ideas.

This looks like that ooooooooold Windows bug. Try using "Document~1" as the
directory name.


--
Jorge Godoy <jgodoy@gmail.com>


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Jorge,

Thanks for the suggestion. But unfortunately, I tried both
\cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.

Casey

Jorge Godoy wrote:
> On Sunday 01 July 2007 21:51:08 Casey Crosbie wrote:
>> Andrej,
>>
>> Thanks for the suggestion. As you said, I tried enclosing "Documents and
>> Setting" and even "C:/Documents and Settings" and neither worked. Please
>> let me know if you have any other ideas.
>
> This looks like that ooooooooold Windows bug. Try using "Document~1" as the
> directory name.
>
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
> Jorge,
>
> Thanks for the suggestion. But unfortunately, I tried both
> \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.

Sorry. It should be up to 8 chars: "Docume~1" or some variation like that
(I've seen ~2 due to some unknown reason). This looks like a Windows
problem on finding directories with spaces in its name. The same happens
with diacriticals...


--
Jorge Godoy <jgodoy@gmail.com>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Jorge,

The \cd C:/Docume~1 worked! Thank you very much for your help!

Casey

Jorge Godoy wrote:
> On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
>> Jorge,
>>
>> Thanks for the suggestion. But unfortunately, I tried both
>> \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.
>
> Sorry. It should be up to 8 chars: "Docume~1" or some variation like that
> (I've seen ~2 due to some unknown reason). This looks like a Windows
> problem on finding directories with spaces in its name. The same happens
> with diacriticals...
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Jorge Godoy <jgodoy@gmail.com> writes:
> On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
>> Jorge,
>> Thanks for the suggestion. But unfortunately, I tried both
>> \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.

> Sorry. It should be up to 8 chars: "Docume~1" or some variation like that
> (I've seen ~2 due to some unknown reason). This looks like a Windows
> problem on finding directories with spaces in its name. The same happens
> with diacriticals...

FWIW, on a Unix machine I get

$ mkdir "foo bar"
$ psql regression
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

regression=# \cd foo bar
\cd: could not change directory to "foo": No such file or directory
regression=# \cd "foo bar"
\cd: could not change directory to ""foo bar"": No such file or directory
regression=# \cd 'foo bar'
regression=# \!pwd
/home/tgl/pgsql/foo bar
regression=#

So maybe single quotes would work better.

I'm not sure if the behavior with double quotes should be considered a
bug or not. Too lazy to check the manual, but I believe psql thinks
single and double quotes are different.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Tom,

Thanks for that bit of insight on using the directories in Unix. I
originally tried no quotes or double quotes for my directory change and
no quotes worked for me. But after your mentioning the single quotes I
tested it out and those seem to work in Windows psql directory changes
as well.

Casey

Tom Lane wrote:
> Jorge Godoy <jgodoy@gmail.com> writes:
>> On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
>>> Jorge,
>>> Thanks for the suggestion. But unfortunately, I tried both
>>> \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.
>
>> Sorry. It should be up to 8 chars: "Docume~1" or some variation like that
>> (I've seen ~2 due to some unknown reason). This looks like a Windows
>> problem on finding directories with spaces in its name. The same happens
>> with diacriticals...
>
> FWIW, on a Unix machine I get
>
> $ mkdir "foo bar"
> $ psql regression
> Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> regression=# \cd foo bar
> \cd: could not change directory to "foo": No such file or directory
> regression=# \cd "foo bar"
> \cd: could not change directory to ""foo bar"": No such file or directory
> regression=# \cd 'foo bar'
> regression=# \!pwd
> /home/tgl/pgsql/foo bar
> regression=#
>
> So maybe single quotes would work better.
>
> I'm not sure if the behavior with double quotes should be considered a
> bug or not. Too lazy to check the manual, but I believe psql thinks
> single and double quotes are different.
>
> regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On Sun, Jul 01, 2007 at 10:46:22PM -0300, Jorge Godoy wrote:
> On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
> > Jorge,
> >
> > Thanks for the suggestion. But unfortunately, I tried both
> > \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.
>
> Sorry. It should be up to 8 chars: "Docume~1" or some variation like that
> (I've seen ~2 due to some unknown reason). This looks like a Windows
> problem on finding directories with spaces in its name. The same happens
> with diacriticals...

To help others in the future, the way to find out what the directory short
name actually is, use "dir /x c:\".

Not that it was the problem this time, but I'm sure someone will need it at
some point.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq