Thread: password

password

From
"Wuttipong Suvaphrom"
Date:
Hi all,
 
when I create users , I use creatuser user1.
Is that user(user1) will be in file pg_shadow ?
How can I create password for that user ?
and How can I encrypt text in  my databases ?
 
thanks a lot.
 
 
 

Re: password

From
"Wuttipong Suvaphrom"
Date:
Thanks for answering my question.
 
May I ask a bit more ?
Do you know how to use ident in pg_hba.conf ? I don't know how it works.
I use pg_access to design databases and link it  together by foreign keys.
So I can't use Select * from sampletable ; It said  no relation.
I must use select t0.name, t0.surname from .... instead of
 
Do you have any suggestion ?
 
 
thanks.