Postgres Pro
Downloads
Home   >   mailing lists

Re: how to encode/encrypt a string - Mailing list pgsql-general

From Tom Lane
Subject Re: how to encode/encrypt a string
Date
Msg-id 17834.1096561679@sss.pgh.pa.us
Whole thread Raw
In response to how to encode/encrypt a string  (Miles Keaton <mileskeaton@gmail.com>)
List pgsql-general
Tree view 
Miles Keaton <mileskeaton@gmail.com> writes:
> In MySQL, to store a big secret (like a credit card number) in the
> database that I didn't want anyone to be able to see without knowing
> the salt/password value, I would do this into a blob-type field:
> INSERT INTO clients(ccnum) VALUES (ENCODE(''433904123121309319', 'xyzzy'));

There are similar functions in contrib/pgcrypto/, I believe.

            regards, tom lane

pgsql-general by date:

Previous
From: Miles Keaton
Date:
Subject: how to encode/encrypt a string
Next
From: Chris Browne
Date:
Subject: Re: how to encode/encrypt a string