From: | Tim Clarke <tim(dot)clarke(at)minerva-analytics(dot)info> |
---|---|
To: | <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: how to install pgcrypto |
Date: | 2018-08-03 09:31:05 |
Message-ID: | 7f58e3d7-6403-6826-2367-3cc87e5a9b86@minerva-analytics.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The psql command is a client - an "interactive terminal". It provides a
command-line version of pgAdmin.
See here for other client applications:
https://www.postgresql.org/docs/10/static/reference-client.html
The "create extension..." command is one that you give to either psql or
pgAdmin; they execute it against the current database.
Tim Clarke
On 03/08/18 09:53, Ze Victor Harry wrote:
> 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
> <http://commands.is/> it from cmd? or in pgadmin query tool? I need
> clearly articulated steps
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2018-08-03 10:12:33 | WAL-dir filling up with wal_level = logical |
Previous Message | Charles Clavadetscher | 2018-08-03 09:21:53 | RE: how to install pgcrypto |