Re: [GENERAL] how to encode/encrypt a string

2004-09-30 Thread Chris Browne
[EMAIL PROTECTED] (Miles Keaton) writes: > still doing my switch from MySQL to PgSQL, and can't figure out what > the comparable function would be for this: > > 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

Re: [GENERAL] how to encode/encrypt a string

2004-09-30 Thread Tom Lane
Miles Keaton <[EMAIL PROTECTED]> 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(''43390

[GENERAL] how to encode/encrypt a string

2004-09-30 Thread Miles Keaton
still doing my switch from MySQL to PgSQL, and can't figure out what the comparable function would be for this: 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 bl