DEV Community

leo
leo

Posted on • Updated on

Does openGauss support the pgcrypto extension?

As the title.

If it is not supported, is there any alternative to hash the string using SHA1, SHA256, SHA384, SHA512, MD5, etc.?
If supported, how should this extension be installed?
I have seen related files in the openGauss source code (openGauss-server-master\contrib\pgcrypto), but there is no contrib folder in the current official docker version and Motianlun online training environment.
If you execute it directly in the database

create extension pgcrypto;
will report an error

Image description
If you execute

apt-get install postgresql-contrib
Then it is actually installed into postgresql, not opengauss

Top comments (0)