Thread: chkpass

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.

    Markus

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
>

Markus Bengts <markus@click3.jsp.fi> writes:
> Can someone help me use this data type?

You need to run the chkpass.sql SQL script to create the type in each
database you want to use it in.

            regards, tom lane