Client's variables

From: "fryk" <fryk(at)tlen(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Client's variables
Date: 2005-01-20 18:41:51
Message-ID: 000901c4ff1f$b4c64be0$56e4acd9@FRYK
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

How to set such variable after (during?) client connection (PHP)?

I want to use it in view - so view could depends on it:

If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:

CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~* (SELECT
MY_VAR FROM ???)

Cheers!
___
fryk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-01-20 18:55:50 Re: Unique Index
Previous Message troyston campano 2005-01-20 18:12:48 Postgresql Security Pen Test