Request a Demo
Home   >   mailing lists

why SELECT query needs relationname (schemaName.tableName) - Mailing list pgsql-sql

From Amar Dhole
Subject why SELECT query needs relationname (schemaName.tableName)
Date
Msg-id B290BFEC59278744B17A7A3CB14307E903A19236@NA-PA-VBE04.na.tibco.com
Whole thread
In response to TABLE PARTITION  (NEVIN ALEX <nevin.alex@hotmail.com>)
Responses Re: why SELECT query needs relationname (schemaName.tableName)
List pgsql-sql
Tree view

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

pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Cumulative result with increment
Next
From: Samuel Gendler
Date:
Subject: Re: why SELECT query needs relationname (schemaName.tableName)