| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: howto set a variable in transaction context |
| Date: | 2008-04-10 11:57:31 |
| Message-ID: | 20080410115731.GJ31345@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am Thu, dem 10.04.2008, um 13:32:04 +0200 mailte Thomas Markus folgendes:
> 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?
Yes, you can use this:
http://www.postgresql.org/docs/current/interactive/runtime-config-custom.html
HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan99 | 2008-04-10 11:57:43 | Re: slow pgsql tables - need to vacuum? |
| Previous Message | CMOS | 2008-04-10 11:45:56 | how to use postgre sql from inside process |