[SQL] hi still i am unable to provide encryption to a particular table....

2006-05-29 Thread Penchalaiah P.








Hi 

 

I have gone thru encryption in postgresql help… but
there I got some message like set some comments in pg_hba.conf file.. if I set
host name and port number here wt I will get… my requirement is to do
encryption to one of my table.. if any body knows about this please help me……..

 

Thanks  &  Regards

Penchal reddy | Software Engineer
  

Infinite Computer Solutions | Exciting Times…Infinite Possibilities... 

SEI-CMMI level 5 | ISO 9001:2000

IT SERVICES |
BPO  


Telecom | Finance
| Healthcare | Manufacturing
| Energy & Utilities | Retail
& Distribution | Government   


Tel +91-80-5193-(Ext:503)| Fax  +91-80-51930009 | Cell No  +91-9980012376|www.infics.com  

Information transmitted by this e-mail is
proprietary to Infinite Computer Solutions and/ or its Customers and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is privileged, confidential or exempt from
disclosure under applicable law. If you are not the intended recipient or it
appears that this mail has been forwarded to you without proper authority, you
are notified that any use or dissemination of this information in any manner is
strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this mail from your records.

 








Re: [SQL] hi still i am unable to provide encryption to a particular table....

2006-05-29 Thread Andrew Sullivan
On Mon, May 29, 2006 at 03:13:59PM +0530, Penchalaiah P. wrote:
> and port number here wt I will get... my requirement is to do encryption
> to one of my table.. if any body knows about this please help me

Is this one-way encryption (i.e. you want a hash?)  You can use
built-in md5 for that.  If you want something more, use the pgcrypto
contrib/ items.

A

-- 
Andrew Sullivan  | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match