Thank you, Tom. Jie
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:06 PM To: Jie Liang Cc: Christian Kratzer; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] [SQL] \set "Jie Liang" <[EMAIL PROTECTED]> writes: > You will see AAA associate with 'whatever', it's an internal variable, > but how could I use it in my SQL query? regression=# \set AAA 'whatever' regression=# select :AAA; ERROR: column "whatever" does not exist regression=# \set AAA '\'whatever\'' regression=# select :AAA; ?column? ---------- whatever (1 row) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
