\set - Mailing list pgsql-admin

From Jie Liang
Subject \set
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB36336D@mail01.stbernard.com
Whole thread Raw
Responses Re: [SQL] \set  (Christian Kratzer <ck@cksoft.de>)
List pgsql-admin
Hi,
How to use an internal variable?
Original question was how to set a variable in postgresql?
If I want to set a variable like start_date='2004-05-10';
How could I use it in my SQL statement?
E.g.

Db> set start_date '2004-05-10'
Db> select start_date as 'start date';

It's not executable!


Thanks.

Jie Liang

pgsql-admin by date:

Previous
From: Paul Tuckfield
Date:
Subject: Re: [PERFORM] Quad processor options
Next
From: Dennis Bjorklund
Date:
Subject: Re: [PERFORM] Quad processor options