On 11/08/2011 10:47 AM, æ± æ¾¤ åæ² wrote:
> Dear Itagaki-san,
>
> Please, no flames about my bad English.
>
> Sorry for the delay in getting back to you. It seemed that I gave the
> insufficient
> information about psql.exe error.
>
> For example, there is the following folder structure.
>
> C:\æ§ç¯ãã©ã«ã
> âA_TBL.sql
>
> Type the folowing command line in a command prompt and I can get the
> error message.
>
> C:\>psql --file="æ§ç¯ãã©ã«ã\A_TBL.sql" --dbname=testdb
If I recall correctly, in shift-JIS, the backslash does not exist. Its
code point was re-used for the Yen symbol (Â¥) instead. On Shift-JIS
windows the Yen symbol is used as a path separator.
http://en.wikipedia.org/wiki/Shift_JISw
http://blogs.msdn.com/b/oldnewthing/archive/2005/10/14/481044.aspx
You will need to use psql in a Unicode command prompt where the
backslash character is available. Alternately you might be able to use ¥
as a directory separator instead, so try:
C:\>psql --file="æ§ç¯ãã©ã«ãÂ¥A_TBL.sql" --dbname=testdb
... or use the UNIX-style path separators that Windows understands and
accepts just fine:
C:\>psql --file="æ§ç¯ãã©ã«ã/A_TBL.sql" --dbname=testdb
--
Craig Ringer