> > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
