Re: my insertion script don't work

kelvin273 wrote:
> Hi all,
> i'm using postgresql 8.3 and i have create a very simple script for insert
> data into database (because i'm testing it, i create and drop/mod frequently
> the tables).
> My script is this:
>
> #!/bin/bash
> echo "Insert start"
> psql -U myself -d test -f 000_ins_users.sql
> psql -U myself -d test -f 001_ins_profile.sql
> psql -U myself -d test -f 002_ins_user_prof.sql
> echo "Insert end"
>
> but i receive this error when i launch this:
>
> Insert start
> : Invalid argument
> : Invalid argumentl
> : Invalid argumentsql

I suspect a stray carriage-return (\r) somewhere. I think the "Invalid
argument" is at the end of the message and is preceded by the
carriage-return.

Did you edit the .sql files in Windows perhaps?

--
Richard Huxton
Archonet Ltd