pgcrypto Questions

2

I'm working on a postgresql base that use pgcrypto to encrypt some columns of the base. Java side, I use JPA to "map" my classes to my database. Currently, to encrypt and decrypt fields in java I...
Savanna asked 29/8, 2018 at 12:20

3

Solved

How to encrypt column in postgres database using pgcrypto addon ? I am using postgres 9.3 and i need to encrypt one of my column , does postgres also support Aes encryption or by any mean i can a...
Spitball asked 7/1, 2016 at 15:8

1

Does Postgres (or a Postgres extension) have a uuid v5 function (ie one that takes in a UUID name space and a string to produce a new UUID)? If not a native function, how would one write this func...
Flask asked 26/9, 2018 at 21:42

1

I need to encrypt some columns in a PostgreSQL 9.6 database. The data being encrypted is inherently sensitive; however, the data are not passwords or other authentication credentials. This data wil...
Gerrygerrymander asked 23/2, 2017 at 23:51

1

Solved

I'd like to call some pgcrypto functions from python. Namely px_crypt. I can't seem to figure out the right object files to link it seems. Here's my code: #include <Python.h> #include "pos...
Egress asked 11/4, 2016 at 14:52

1

Solved

I intsalled the pgcrypto extension as the superuser like this: CREATE EXTENSION pgcrypto; As the superuser, I tested it, and it works find: select gen_salt('bf'); gen_salt --------------------...
Ignazio asked 14/9, 2015 at 0:49

1

Solved

I would like to encrypt an area_code column in my postgreSQL database with aes 256 encryption. Here is what happens.. I am able to encrypt it easily but I am not able to decrypt it. Here is the enc...
Abruption asked 30/10, 2014 at 15:21

2

I am coding up the security for a website in express.js and postgresql db. Now I have been reading about salting and hashing and I have the code set up with pdkdf2 using the crypto module, but my i...
Reina asked 13/1, 2014 at 15:28

2

Solved

I have oracle database to move on to new postgresql server. Some tables are having field sesitive and those are all encryted through DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT/DESDECRYPT. The problem is...
Annulus asked 27/9, 2012 at 5:16
1

© 2022 - 2024 — McMap. All rights reserved.