Postgresql Schema Path permanently

Question

I need to set schema path in Postgres so that I don't every time specify schema dot table e.g. schema2.table. Set schema path (SET SCHEMA PATH a,b,c) only seems to work for one query session on mac, after I close query window (on pg-admin) the path variable sets itself back to default. How can I make it perm ?

Would greatly appreciate any help on this matter.

(op sys: Snow Leopard: db: Postgresql 8.4.*)

Thx

p.s. I have also tried set_config but no joy

Answer 1

Have you tried the search_path option in the configuration file ?

Answer 2

(And if you have no admin access to the server)

ALTER ROLE <your_login_role> SET search_path TO a,b,c;