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] mail alert

2009-08-14 Thread Christopher Browne
t...@tim-landscheidt.de (Tim Landscheidt) writes: > Alvaro Herrera wrote: > >>> > It's on Windows > >>> I'd go with notify and a listener written in C using c-client to send >>> emails, but only because I've used those before. > >> I wouldn't write it in C but rather Perl or Python, but whatever s

Re: [SQL] simple? query

2009-08-14 Thread Tim Landscheidt
"Relyea, Mike" wrote: >> The goal is, where uid not equals to 'janvleuven10' a new >> record should be inserted with the uid, and registered=0 > So if a record is found you want to update it and if a record isn't > found you want to insert it. I think you'll probably want to use > plpgsql http:

Re: [SQL] simple? query

2009-08-14 Thread Relyea, Mike
> From: Jan Verheyden [mailto:jan.verhey...@uz.kuleuven.ac.be] > Sent: Friday, August 14, 2009 9:03 AM > To: Relyea, Mike > Subject: RE: [SQL] simple? query > > The goal is, where uid not equals to 'janvleuven10' a new > record should be inserted with the uid, and registered=0 > > Regards, > >

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

Re: [SQL] simple? query

2009-08-14 Thread Relyea, Mike
> From: Relyea, Mike [mailto:mike.rel...@xerox.com] > Sent: Thursday, August 13, 2009 10:47 PM > > > From: pgsql-sql-ow...@postgresql.org > [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Jan Verheyden > > Subject: [SQL] simple? query > > > > Hi, > > I was trying to run following query but d

[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

Re: [SQL] simple? query

2009-08-14 Thread Jasen Betts
On 2009-08-13, Jan Verheyden wrote: > --_004_E30C7040DE22624185BAD4093190B54437BE5DB4C1EX2007MBX2uzk_ > Content-Type: multipart/alternative; > boundary="_000_E30C7040DE22624185BAD4093190B54437BE5DB4C1EX2007MBX2uzk_" > > --_000_E30C7040DE22624185BAD4093190B54437BE5DB4C1EX2007MBX2uzk_ > Conten