Re: Junk queries with variables? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Junk queries with variables?
Date
Msg-id 20050224171531.GA53540@winnie.fuhr.org
Whole thread Raw
In response to Re: Junk queries with variables?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
On Thu, Feb 24, 2005 at 10:04:50AM -0700, Steve - DND wrote:

> > \set name '\'Some Name\''
> > SELECT * FROM foo WHERE name = :name;
> 
> Whenever I try the above I get an error at the backslash. Do I need to
> create a different language for this? Right now I only have plpgsql
> available.

Did you try it in psql?  As I mentioned, \set is a psql (client side)
command.

http://www.postgresql.org/docs/8.0/static/app-psql.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: "Steve - DND"
Date:
Subject: Re: Junk queries with variables?
Next
From: Bricklen Anderson
Date:
Subject: Re: Junk queries with variables?