X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A4A1853C91 for ; Thu, 24 Feb 2005 17:10:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17806-03 for ; Thu, 24 Feb 2005 17:10:35 +0000 (GMT) Received: from fed1rmmtao12.cox.net (fed1rmmtao12.cox.net [68.230.241.27]) by svr1.postgresql.org (Postfix) with ESMTP id ACB6653C92 for ; Thu, 24 Feb 2005 17:10:33 +0000 (GMT) Received: from dnd2 ([68.2.114.10]) by fed1rmmtao12.cox.net (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP id <20050224171044.RLLY13819.fed1rmmtao12.cox.net@dnd2>; Thu, 24 Feb 2005 12:10:44 -0500 From: "Steve - DND" To: "Michael Fuhr" Cc: Subject: Re: Junk queries with variables? Date: Thu, 24 Feb 2005 10:10:43 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: <20050224074045.GA30413@winnie.fuhr.org> Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/311 X-Sequence-Number: 20421 > > I don't know about pgAdmin, but in psql you can use \set: > > \set id 1 > SELECT * FROM foo WHERE id = :id; > > \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. Thanks, Steve