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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general