Re: [SQL] Field or record level encryption / decryption

2009-08-14 Thread Joshua Tolley
On Sat, Aug 15, 2009 at 12:07:54AM +0800, Hengky Lie wrote: > Thanks to all who response my question. > > I have checked the doc, but it seems too advance for my postgresql > knowledge. > > Other question is where can i get pgcrypto modules ? You haven't told us how you installed PostgreSQL, but

Re: [SQL] Field or record level encryption / decryption

2009-08-14 Thread Hengky Lie
Thanks to all who response my question. I have checked the doc, but it seems too advance for my postgresql knowledge. Other question is where can i get pgcrypto modules ? For simple record encryption that contains date field, varchar, integer and text, what encryption i can use ? As far as

Re: [SQL] Field or record level encryption / decryption

2009-08-14 Thread Christopher Browne
hengkyliwand...@gmail.com (Hengky Lie) writes: > Anyone know what function i can use to encrypt / decrypt field or > record ? > > When record saved, it saved in encrypt format. When i need to read > data, i just call decrypt function. > > I am using MS Access 2003 and Postgresql 8.3 I'd suggest r

Re: [SQL] Field or record level encryption / decryption

2009-08-14 Thread Joshua Tolley
On Fri, Aug 14, 2009 at 05:20:58PM +0800, Hengky Lie wrote: > Hi, > > Anyone know what function i can use to encrypt / decrypt field or > record ? > > When record saved, it saved in encrypt format. When i need to read data, > i just call decrypt function. See the pgcrypto extension: http://www

[SQL] Field or record level encryption / decryption

2009-08-14 Thread Hengky Lie
Hi, Anyone know what function i can use to encrypt / decrypt field or record ? When record saved, it saved in encrypt format. When i need to read data, i just call decrypt function. I am using MS Access 2003 and Postgresql 8.3 Thanks a lot. Regards, Hengky -- Sent via pgsql-sql maili