Re: user defined variable per session

> I need to create user defined variable in every database session.
> In Sybase ASA is equivalent:
> CREATE VARIABLE name TYPE;
>
> I need use this in views. Is it possible???

What about

test=> \set myvar 5
test=> select :myvar;
 ?column?
----------
        5
(1 row)

hth
cl.