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.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings