kandiah ratnavale <ratnavale(at)shaw(dot)ca> writes:
> could you please tell me what is wrong here?
> how would i change to user bruce?
You are confusing unix users with postgres users. They are different
so the su command does not work. You can use the -U switch to psql to
connect as another user
psql -U bruce -d movies
Read the psql(1) and createuser(1) manual pages for details.
Regards,
Manuel.