kandiah ratnavale <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]