postgresql add tag
Anonymous 2226
I have a question about this fiddle:

<>https://dbfiddle.uk?rdbms=postgres_11&fiddle=e9eb2523d6f2737ac1b69f44f908894f

This works in any local environment, but the question is, how to mask the data or how to encrypt in smaller values.
Top Answer
Truilus
`pgp_sym_encrypt()` is provided by the extension [pgcrypto](https://www.postgresql.org/docs/current/pgcrypto.html). If it works in your local database, then you have installed the extension there. 

You need to install the extension in every environment where you want to use it. 

To do that, connect to the database as the superuser (typically `postgres`)  then run: 

     create extension pgcrypto;
     
    

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.