hello list,
i am new to postgres and am puzzled how to solve the untrusted admin problem.
i am having very sensitive data (accounts and payroll) on postgresql
server. the goal i want to achive is that even the sys. admin/database
admin. should be able to read the data. i understand that the solution
lies in encrypting the fields.
the fields i would like to encrypt are numeric. according to my
understanding SQL queirues in the application will fail due to this.
is it possible to accomplish this task ?
i am using postgres 8.1, its a perl based application running on apache.
Sandeep