Re: psql and md5

В Пнд, 02.08.2004, в 19:21, Simon Windsor пишет:
> Hi
>
> You can always generate the md5 password using perl/php and store the password
> in database. I believe the next version of pgsql will have an internal md5
> function.

template1=# select version();

version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.3.3 20040216 (Red Hat Linux 3.3.3-2.1)
(1 запись)

template1=# select md5('foo');
md5
----------------------------------
acbd18db4cc2f85cedef654fccc4a4d8
(1 запись)

>
> Simon
>
> On Monday 02 August 2004 15:43, John DeSoi wrote:
> > Is there a way to provide a md5 password directly to psql? I'm aware of
> > pgpass but I would like to store a md5 password in some other location
> > and then use it to execute commands with psql.
> >
> > Thanks,
> >
> > John DeSoi, Ph.D.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
Markus Bertheau <twanger(at)bluetwanger(dot)de>