sql-files with control characters at the beginning
От | Andreas Laggner |
---|---|
Тема | sql-files with control characters at the beginning |
Дата | |
Msg-id | 4B853CCB.8020104@vti.bund.de обсуждение исходный текст |
Ответы |
Re: sql-files with control characters at the
beginning
|
Список | pgadmin-support |
Hi List, i want to execute my sql-files, written with pgadmin 1.10.0 (from binaries for openSuse 11.2 64bit) directly on the server via nohup. But since 1.10 (i never had that problem in 1.08) the sql-file saved by pgadmin begins with 3 control characters. I can only see these characters, if i open the sql-file with mc and go to edit hexadecimal - i can replace these three by 20 20 20 (three space) and then i can run the sql-file, otherwise psql returns: syntax error at or near <feff>. This occurs on openSuse 11.2 64bit and on openSuse 11.1 64bit. Why puts pgadmin thiese three characters to my files?? cheers Andreas -- Dipl. Geoökologe Andreas Laggner Institut für Agrarrelevante Klimaforschung (AK) des vTI Arbeitsgruppe Emissionsinventare Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Institute of Agricultural Climate Research (AK) of the vTI Johann Heinrich von Thünen-Institute (vTI), Federal Research Institute for Rural Areas, Forestry and Fisheries Bundesallee 50 D-38116 Braunschweig Tel.: (+49) (0)531 596 2636 Fax : (+49) (0)531 596 2645 E-mail: andreas.laggner@vti.bund.de Homepage: http://www.vti.bund.de
В списке pgadmin-support по дате отправления: