Steve - DND wrote:
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

\set name text('Some Name')
SELECT * FROM foo WHERE name = :name;


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to