Miles Keaton <mileskeaton(at)gmail(dot)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