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.