chkpass

Started by Markus Bengtsover 23 years ago3 messagesgeneral
Jump to latest
#1Markus Bengts
markus@click3.jsp.fi

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

#2Markus Bengts
markus@click3.jsp.fi
In reply to: Markus Bengts (#1)
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?

Show quoted text

Markus

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Markus Bengts (#2)
Re: chkpass

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