Trying to use the chkpass type to store passwords as described here . But when I try to execute create table test (p chkpass) , I get:

 ERROR: type "chkpass" does not exist LINE 1: create table test (p chkpass);

Why is this happening and how to fix it?

select version() gives PostgreSQL 9.6.2 on x86_64-apple-darwin... version must support ...

  • The cryptographic system uses the unix function; The first password is considered. Are you sure this is a good idea? - D-side
  • @ D-side I think very few people use passwords longer than 8 characters ... - Pavel

1 answer 1

This is a module and you need to install it. This is done by request.

 CREATE EXTENSION IF NOT EXISTS chkpass;

Doka https://postgrespro.ru/docs/postgrespro/9.6/sql-createextension