Re: [SQL] \set
Re: [SQL] \set
От:
"Jie Liang" <jie@stbernard.com>
Дата:
Thank you, Tom. Jie -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Wednesday, May 12, 2004 4:06 PM To: Jie Liang Cc: Christian Kratzer; pgsql-admin@postgresql.org; pgsql-sql@postgresql.org Subject: Re: [ADMIN] [SQL] \set "Jie Liang" 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