On Jan 14, 2006, at 23:54 , Jeff Boes wrote:
> Tony Wasson wrote:
>> Stuff like this works for me in a SQL file.... \set edate
>> 'CURRENT_DATE::DATE' SELECT * FROM some_table WHERE update_date
>> = :edate;
>
> Sure, but that was not my question. I want to be able to set the
> variable on the command line, BUT have it default to a value inside
> the SQL script if not present on the command line.
You could write a wrapper script that would accept a command line
argument and load the file with the appropriate SET statement prepended.
Michael Glaesemann
grzm myrealbox com