Postgres Pro
Downloads
Home   >   mailing lists

Re: substitute variable in sql? - Mailing list pgsql-general

From Doug McNaught
Subject Re: substitute variable in sql?
Date
Msg-id m3wuo1fca4.fsf@varsoon.wireboard.com
Whole thread Raw
In response to substitute variable in sql?  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Responses Re: substitute variable in sql?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:

> Running PostgreSQL 7.2.1 on RedHat Linux 7.2:
>
> I have a query where I have to replace the
> date parameter each time I run the query.
>
> Is there a way to substitute just the date
> parameter in the sql without having to
> edit the script, re-run and edit again?

There are loads of ways to do this.  What client language are you
using?  Are you running 'psql' from a shell script?

-Doug

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: substitute variable in sql?
Next
From: "Johnson, Shaunn"
Date:
Subject: Re: substitute variable in sql?