how to install pgcrypto

From: Ze Victor Harry <assayabadi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to install pgcrypto
Date: 2018-08-03 08:53:43
Message-ID: CAPR6t4=S7rK9RyVAitzF2HD-RDCjFJN0+4zUViBt_vx5iLM5Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello again I have a small problem here can someone tell me briefly how to
do it? I am getting this error When I give ant fresh_install it gives error
PostgreSQL 'pgcrypto' extension installed /up to date? False (not
installed) Create extension pgcrypto
<https://stackoverflow.com/questions/45408745/when-i-give-ant-fresh-install-it-gives-error-postgresql-pgcrypto-extension-ins>
.
I have tried to look up for solutions and they all say I have to run a
command
# Login to your "dspace" database as a superuser
psql --username=postgres dspace
# Enable the pgcrypto extension on this database
CREATE EXTENSION pgcrypto;
but where I got confused is from where do I run these commands.is it from
cmd? or in pgadmin query tool? I need clearly articulated steps

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2018-08-03 09:21:53 RE: how to install pgcrypto
Previous Message Pavel Raiskup 2018-08-03 08:30:51 Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)