Re: SQL from shell script

Is there really NO WAY you could do this in perl or java?  Database
interfaces in these languages are easy to use and designed to avoid the
types of stuff you are doing below.  They are generally quite flexible
and mainstream.  For perl, see
http://cpan.uwinnipeg.ca/htdocs/DBI/DBI.html as an example.

Another way to go about the problem is to direct all your SQL queries
into a temporary table and then use SQL COPY from that temporary table
to a file.  You could then generate one large SQL command and push that
through psql.

Sean

On Jan 14, 2005, at 1:36 PM, sarlav kumar wrote:

> Hi All,
>  
> I have the following statements in my shell script:
>  
> echo $PGPASSWORD | psql -U $USER -h $HOST -d $DBNAME -c "select * from
> affiliate_batch where tx_dt < ' "$DATE" ' order by id; " >
> $1$DATE.1.txt
>  
> echo $PGPASSWORD | psql -U $USER -h $HOST -d $DBNAME -c "select * from
> affiliate_event where dt< ' "$DATE " ' order by id; " > $1$DATE.2.txt
>  
> I will be adding more statements in this file. I would like to know if
> there is a way to avoid specifying the connection everytime. I would
> like to make the connection once and then execute the set of SQL
> statements and disconnect from the database.
>   
> It would be great if someone could help me.
>  
> Thanks!
> Saranya
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com