Re: my insertion script don't work

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