On Thursday 26 October 2006 14:04, km <km@xxxxxxxxxxxxxx> 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.