howto set a variable in transaction context

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: howto set a variable in transaction context
Date: 2008-04-10 11:32:04
Message-ID: 47FDFAB4.5090605@proventis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi list,

how can i set a variable, which content is only visible in current
transaction?
i know the way to create a temp table with

create temp table ... on commit drop

but i dont like that way. something like
|
set_config(setting_name, new_value, is_local)

is it possible?

regards
thomas
|

Attachment Content-Type Size
t_markus.vcf text/x-vcard 255 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CMOS 2008-04-10 11:45:56 how to use postgre sql from inside process
Previous Message Stefan Schwarzer 2008-04-10 11:11:06 Re: Dump/Transfer Sequence Problems