On Thursday 26 October 2006 14:04, km <km(at)mrna(dot)tn(dot)nic(dot)in> wrote: >> so that when the user logis in and accesses a database via psql he should > be able to land into his schema. how do i do that ? any tips ? alter role rolename set search_path=path1[,path2...]; -- Ginsberg's Theorem: 1) You can't win. 2) You can't break even. 3) You can't quit the game.