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?

kretsch...@tux:~$ echo "select current_date" > date.sql
kretsch...@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to