[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

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

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 the