Re: Need help with bash script and postgresql

Hi Chuck,

I am no expert but this should definitely be possible with postgres.

The posgres command in the loop should look like so (not sure about the
password):

psql -U <user> -d mydatabase -c ""insert into mytable (aaa,bbb) values
('xxx', 'yyy');"

Cheers,

Andy

On 23/07/07, Chuck Payne <cpayne(at)magigames(dot)net> 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.
>
> Thanks,
>
> Payne
>
> ----------------------------------------------------
> www.britishscifiexchange.com
> www.magigames.net