Re: SQL from shell script

sarlav kumar wrote:
> Hi,
>
> I haven't used PERL or JAVA to do this before. I will look at the
> documentation and try out using perl DBI.
>
> But is there a way to proceed with the way I started?

You'll have to figure out another way to handle the password, but you
can pass multiple commands to psql as follows:

echo echo "select * from table1; select * from table2;"|psql rnd

I don't know if there is a limit to the # of commands you can send in
this manner, but if it's a good many you can make more readable as follows:

echo "select * from table1;
    select * from table2;
    select * from table3;
    "|psql rnd

Still, you'll have to deal with the password a different way likely.

--
Until later, Geoffrey