| From: | Moritz Sinn <moritz(at)freesources(dot)org> |
|---|---|
| To: | "Joel Burton" <joel(at)joelburton(dot)com> |
| Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: user defined variables |
| Date: | 2002-05-24 16:13:54 |
| Message-ID: | m34rgxttfh.fsf@freesources.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joel Burton" <joel(at)joelburton(dot)com> writes:
> In the psql client, you can set a variable with the "\set" command, or using
> "--set" at startup. So "psql --set UID=xxxx" will let you use the the UID as
> "SELECT * FROM USER WHERE uid= :UID".
>
> Will this work for you?
>
> - J.
well, i'm using the php functions for communicating with postgresql. but
this means that it is possible.
has someone an idea how i can set such a variable when i open the
connection with php?
thanks,
moritz
--
<grin> seen jhm
<dpkg> jhm is Sarek, and jhm is on the channel right now!
* JHM wonders why dpkg remembers that particular nick.
<grin> dpkg: Sarek? ermm, sure, and I am Khan
-- Seen on #Debian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Black | 2002-05-24 16:46:20 | Case Insensitive Data Type |
| Previous Message | Olonichev Sergei | 2002-05-24 15:55:18 | Re: How to add big amounts of data into database? |