pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

(no subject)
2+ messages / 2 participants
[nested] [flat]

* (no subject)
@ 2005-01-28 08:39  Deepthi Darshan <deepthi@granwill.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Deepthi Darshan @ 2005-01-28 08:39 UTC (permalink / raw)
  To: pgsql-sql

Hi,

I have a database which has been set to encoding UTF-8.

I have a table in this database in which i store the details of all the
registered users. I am using PL/PGSQL and using one function i am entering the
values into the database. There is one column for entering the passwords of all
registered users. I want to store these passwords in an encrypted manner in the
table. Can i encrypt the password in the stored procedure and will i not loose
any data by entering the passwords in an encrytped manner.

Thanks in advance,

Regards,
deepthi





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
@ 2005-01-28 09:11  Richard Huxton <dev@archonet.com>
  parent: Deepthi Darshan <deepthi@granwill.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2005-01-28 09:11 UTC (permalink / raw)
  To: Deepthi Darshan <deepthi@granwill.com>; +Cc: pgsql-sql

Deepthi Darshan wrote:
> Hi,
> 
> I have a database which has been set to encoding UTF-8.
> 
> I have a table in this database in which i store the details of all the
> registered users. I am using PL/PGSQL and using one function i am entering the
> values into the database. There is one column for entering the passwords of all
> registered users. I want to store these passwords in an encrypted manner in the
> table. Can i encrypt the password in the stored procedure and will i not loose
> any data by entering the passwords in an encrytped manner.

There are a range of encryption functions available in contrib/pgcrypto 
in the source distribution.

Some encryption is one-way (so you can't recover the original password, 
just confirm a provided password matches it). Other encryption is 
two-way, but you usually have a separate key to encrypt the passwords then.

--
   Richard Huxton
   Archonet Ltd



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-01-28 09:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-28 08:39  Deepthi Darshan <deepthi@granwill.com>
2005-01-28 09:11 ` Re: Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox