Re: Need help with bash script and postgresql

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: cpayne(at)magigames(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help with bash script and postgresql
Date: 2007-07-23 10:04:47
Message-ID: 1185185087.10048.14.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2007-07-23 at 05:34 -0400, Chuck Payne wrote:
>
> 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.

I can't really offer any help yet.. (still playing with it)
but.. can't you do use copy instead of inserts?

eg: psql -U xxx -W DBname -c "\copy from '/tmp/myfile.txt' with csv
header"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-07-23 10:09:28 Re: Need help with bash script and postgresql
Previous Message Andy Dale 2007-07-23 10:04:08 Re: Need help with bash script and postgresql