Need help with bash script and postgresql

From: "Chuck Payne" <cpayne(at)magigames(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Need help with bash script and postgresql
Date: 2007-07-23 09:34:37
Message-ID: 5637.216.235.158.34.1185183277.squirrel@webmail.magigames.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Dale 2007-07-23 10:04:08 Re: Need help with bash script and postgresql
Previous Message Richard Huxton 2007-07-23 08:06:43 Re: Import to excel to postgres based website?