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
In response to
pgsql-sql by date
|Next:||From: Samuel Gendler||Date: 2011-02-08 07:16:04|
|Subject: Re: why SELECT query needs relationname (schemaName.tableName)|
|Previous:||From: Steve Crawford||Date: 2011-02-07 22:13:30|
|Subject: Re: Cumulative result with increment|