Search Postgresql Archives

Re: my insertion script don't work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux