Re: Date variables in psql - Mailing list pgsql-general

On Thu, 7 Oct 2004, Tom Lane wrote:

> It's fairly painful to get single quotes into a psql variable;
> AFAIK you have to do it like this:
> \set proc_date '\'6/30/2004\''


Thanks that worked.
I figure I needed to escape the single quotes, but I had tried
\'6/30/2004\', which did not work.