Hello
I don't understand well, what you want to do. You can
cat myfile.txt | psql database
or like your sample
for i in `cat myfile.txt` ; do psql mydatabase -c "insert into
mytable (aaa,bbb) values ("xxx", "yyy");"
...
regards
Pavel Stehule
2007/7/23, Chuck Payne <[EMAIL PROTECTED]>:
Hey,
I have spend the last several days looking for a website or how to that
would show me how to call postgresql in bash script. I know that in mysql I
can do like this
for i in `cat myfile.txt` ; do mysql -uxxx -pxxxx -Asse mydatabase "insert
into mytable (aaa,bbb) values ("xxx", "yyy");"
I have tried to do what with pgsql and it not working. I have looked at my
two books I have and they are very limited.
Can some what tell if postgre has flag like -Asse? Or show me a simple
script they have do that is kinda like above.
Thanks,
Payne
----------------------------------------------------
www.britishscifiexchange.com
www.magigames.net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
