User variables like: SET @a='test';

From: "Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: User variables like: SET @a='test';
Date: 2006-01-13 15:39:22
Message-ID: 00b701c61857$86762970$9000a8c0@taschenrechner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

based on my other question I am trying to find solutions on myself.
I am searching for something like user variables:

SET @a='test';

As desriped here:

http://dev.mysql.com/doc/refman/5.0/en/variables.html

How can I do that in postgresql?

Is there a workaround?

Maybe creating a new configuration variable and using that all the time
based on the session?
How can I do that?

Thank you,

Christian

Browse pgsql-novice by date

  From Date Subject
Next Message Ângelo Marcos Rigo 2006-01-13 17:40:25 Re: How to set a Default Value
Previous Message Christian Hofmann 2006-01-13 15:32:32 Setting a variable for current session (set, define or something) for auditing