Oleg Lebedev writes:
> My application needs to store user names and passwords in the database
> via JDBC connection. What is the right way to do this?
One table, one column for the name, one column for the password.
> What should be the database type of the password column?
text or bytea, depending on how you encrypt it.
> How do I encrypt the password before sending it to the database?
Check out contrib/pgcrypto.
> What other database settings need to be enabled for this to work?
None.
--
Peter Eisentraut peter_e@gmx.net
