On Tue, Sep 19, 2017 at 12:42:40PM -0700, Jeff Janes wrote: > On Tue, Sep 19, 2017 at 12:20 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > > On Wed, Sep 6, 2017 at 04:19:52PM -0400, Stephen Cook wrote: > > Hello! > > > > Is there a way to decrypt data encrypted with the pgcrypto "encrypt" > > function, outside the database? Assuming that I know the key etc... > > Yes, I think so. pgcrypto uses openssl and gpg internally, so using > those tools should work. > > > I know that pgp_sym_encrypt and pgp_sym_decrypt interoperates well with > "outside the database" gpg, although dealing with armoring and de-armoring as > well as text mode or binary mode is a bit of a bother until you get used to it. > > But he seems to be asking about the "F.25.4. Raw Encryption Functions". I > wouldn't want to reassure him that it would be easy to make those work outside > the database, without having seen it done. But it should of course be possible > to make it work, even if that means rearranging the code of pgcrypto and > compiling into something that is standalone. Uh, it should be possible with openssl, but I have never tried it. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
