Re: Date variables in psql

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Date variables in psql
Date: 2004-10-07 17:38:05
Message-ID: 20041007133623.E64843@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron St-Pierre 2004-10-07 18:10:29 Re: Conditional Relationships?
Previous Message Steve Atkins 2004-10-07 17:30:46 Re: pre-sroted table (w/ index)