Thread: my insertion script don't work
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 Insert end It looks like that the filename argument is not ok...and the error is different because the filename (length of that) is different...can you help me, please? Thank you very much! -- View this message in context: http://www.nabble.com/my-insertion-script-don%27t-work-tp23611570p23611570.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
In response to kelvin273 :
>
> 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
> Insert end
>
> It looks like that the filename argument is not ok...and the error is
> different because the filename (length of that) is different...can you help
> me, please?
looks okay, maybe the sql-files are wrong?
kretschmer@tux:~$ echo "select current_date" > date.sql
kretschmer@tux:~$ psql test -f date.sql
date
------------
2009-05-19
(1 row)
I'm sure, your files contains invalid sql-code.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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
Solved...mine error...the script was create under windows and launched under linux...the file format was not corrent... Thanks :-) 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 > Insert end > > It looks like that the filename argument is not ok...and the error is > different because the filename (length of that) is different...can you > help me, please? > Thank you very much! > > > -- View this message in context: http://www.nabble.com/my-insertion-script-don%27t-work-tp23611570p23613254.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.