Looks like it could be a knocked BOM. Can you open the file in a bed editor and check the first couple of bytes?
/Magnus > ------- Original Message ------- > From: Kev <[EMAIL PROTECTED]> > To: pgadmin-support@postgresql.org > Sent: 08-04-07, 22:34:42 > Subject: [pgadmin-support] win32 psql syntax error running any .sql created > by the query editor > > Hi, > > This is reproducible every time on my Windows 2003 Server box running > pgAdmin3 1.8.2 and pgsql 8.3. > > 1. Open the query editor. > 2. Type any valid query. > 3. Save. > 4. In a DOS box, run psql -f on the file you just saved. > > I get the following error: > > psql:path/to/test.sql:71: ERROR: syntax error at or near "п»ї" > LINE 1: п»їselect * from cust > > If I open the file in TextPad, it says it's of UNIX type. If I then > save it again using TextPad and run it, it runs fine without errors. > > This also happens even if I go Edit->Line Ends-> and choose either DOS > or UNIX in the query editor and then save again. > > I could be wrong, but this sounds like a bug. Thoughts or > suggestions? > > Thanks, > Kev > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
