You need to modify the search_path for that user. Read the first section of this page very carefully: http://www.postgresql.org/docs/8.4/static/runtime-config-client.html
The schema that is used for new objects that don't have an explicit schema is always the first schema in the search_path. You can permanently alter the search_path for the user like this: alter user <username> set search_path to cust, other_schema, public, pg_catalog; There's more info on search_path here: http://www.postgresql.org/docs/8.4/static/ddl-schemas.html On Mon, Feb 7, 2011 at 10:56 PM, Amar Dhole <adh...@tibco.com> wrote: > Hi All, > > > > I have a query regarding database. > > > > I have database ‘customer’ which is having schema ‘cust.’ > > > > I have added my tables and data into ‘cust’. But when I try to run the sql > queries against this schema I need to add ‘cust’ as a relationName for every > query. But same is not applicable for public schema. > > > > Same is applicable when I query with jdbc. > > > > Can any one guide me how can I make my ‘cust’ schema to work like public > schema means for all the sqls I don’t need to append schema name as > relationanme. > > > Thanks > > Amar >
