Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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
[GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
On 7/2/07, Casey Crosbie [EMAIL PROTECTED] 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 -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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 [EMAIL PROTECTED] 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/
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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 old Windows bug. Try using Document~1 as the directory name. -- Jorge Godoy [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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 old Windows bug. Try using Document~1 as the directory name. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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/
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
Jorge Godoy [EMAIL PROTECTED] 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
Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows
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 [EMAIL PROTECTED] 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/