Re: store files encrypted with pgcrypto

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

elmarkivp wrote:
Hi, i'm trying to store files encrypted in postgres 8.3.4, using sym_encrypt_bytea function. this is quoted from the postgres8.3 documentation, thats was my guide, below is the php code i have used to make it, with no results and the respective errors. FROM F.20.3.1. pgp_sym_encrypt() pgp_sym_encrypt(data text, psw text [, options text ]) returns bytea pgp_sym_encrypt_bytea(data bytea, psw text [, options text ]) returns bytea Encrypt data with a symmetric PGP key psw. The options parameter can contain option settings, as described below.
F.20.3.2. pgp_sym_decrypt()
pgp_sym_decrypt(msg bytea, psw text [, options text ]) returns text pgp_sym_decrypt_bytea(msg bytea, psw text [, options text ]) returns bytea


ERRORS: ERROR: No function matches the given name and argument types. You might need to add explicit type casts ERROR: function pgp_sym_encrypt_bytea(unknown, integer, unknown) does not exist

pgcrypto is a contrib module in pg 8.3 (ie not built in by default). Did you install the module?

There are instructions on how to do that here:

Postgresql & php tutorials

Sent via pgsql-php mailing list (pgsql-php@xxxxxxxxxxxxxx)
To make changes to your subscription:

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux