470,614 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

public key functions for postgresql ?


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

Nov 11 '05 #1
4 1981
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*******@postgresql.org

Nov 11 '05 #2
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

Nov 11 '05 #3

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.pha.pa.us | (610) 359-1001
+ 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

Nov 11 '05 #4
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/N7Qk21dVnhLsBV0RAnktAJwOfUPECQCuPAkfb5NQqEJwiS7Fdg CfW8qp
QQBww1Oc5uVV0+SG5bkxyIU=
=k9yl
-----END PGP SIGNATURE-----

Nov 11 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by giant food | last post: by
9 posts views Thread by Thomas LeBlanc | last post: by
5 posts views Thread by Rich Hall | last post: by
5 posts views Thread by Zlatko Matiś | last post: by
5 posts views Thread by Robert Fitzpatrick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.