Re: chkpass

On Sun, 5 Jan 2003, Markus wrote:

>
> Hello,
>
> I have just done an rpm-installation of postgresql-7.3.1-1PGDG and
> postgresql-contrib-7.3.1-1PGDG.
>
> The documentation says that chkpass is a password type for storing and
> comparing encrypted passwords. What should I do to be able to create a
> table with a field of type chkpass?
>
> create table passtable (username varchar(30), passwd chkpass);
>
> does not work.
>

Can someone help me use this data type? Is it already implemented, or is
there something else in the shared library file? I have tried

load '/usr/lib/pgsql/chkpass.so';

but the type is not available in the pg_type system catalog. Can I somehow
add it with create type?


>     Markus
>