Michael Black <michaelblack75052@xxxxxxxxxxx> wrote: > > If the purpose of encryption is for financial or medica data transmission security, or something of a higher order, you may want to implement a stronger type of security such as SSL or PGP or some other type of public/private key process. > > You could create a schema that contains views of the data with out the sensitive data and have the users use that schema for their needs, assumes that it basically used to view or report on the data. Thanks for the input, Michael. We're already working on using PKI, the big problem we're having is the speed of access when an administrator needs to search through the encrypted data. -- Bill Moran http://www.potentialtech.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
