By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

public key functions for postgresql ?

P: n/a

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
Share this Question
Share on Google+
4 Replies

P: n/a
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

P: n/a
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

P: n/a

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

P: n/a
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.