public key functions for postgresql ?

[Gianni Mariani]

I need to store some sensitive data and I want to use public keys so
anyone can encrypt the data but can only be decrupted by certain users.

Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.

It's probably not that hard, just don't want to re-invent the wheel. I
could probably do it from plperl since there are plenty of perl PK tools.

Reccomendations ?

G
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Gianni Mariani <gi****@mariani .ws> writes:

Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.

Look in contrib/pgcrypto.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Gianni Mariani]

Tom Lane wrote:

Gianni Mariani <gi****@mariani .ws> writes:

Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.

Look in contrib/pgcrypto.

regards, tom lane

Thanks for the pointer, I read the docs and I see no public key crypto
stuff there. Did I miss somthing ?

I suppose it would be a good point to start adding some new public key
functions.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Bruce Momjian]

I think you are right --- there are no public key functions in there.
Perhaps the easiest way would be to detect a public-key library and make
functions in pg_crypto to call them if they exist.

---------------------------------------------------------------------------

Gianni Mariani wrote:

Tom Lane wrote:

Gianni Mariani <gi****@mariani .ws> writes:

Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.

Look in contrib/pgcrypto.

regards, tom lane

Thanks for the pointer, I read the docs and I see no public key crypto
stuff there. Did I miss somthing ?

I suppose it would be a good point to start adding some new public key
functions.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Franco Bruno Borghesi]

This package seems to be very good, it includes all kind of asymetric
encryption/decryption functions, and data types to store keys into
postgresql tables.

It still unfinished, but maybe it already incorporates the functionality
your looking for.

Docs:
http://www.dimensional.com/~bgiles/pkixdoc/book1.html

Download:
http://www.dimensional.com/~bgiles/index1.html

hope it helps.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/N7Qk21dVnhLsBV0 RAnktAJwOfUPECQ CuPAkfb5NQqEJwi S7FdgCfW8qp
QQBww1Oc5uVV0+S G5bkxyIU=
=k9yl
-----END PGP SIGNATURE-----