[SQL] Cumulative result with increment

Hello, I am struggling with what is probably a simple problem but I am coming up blank. In the interest of full disclosure I am not a very savy programmer by any stretch. I have a table of data from an external source which contains numbers of events per operating group per hour per day, kind of

Re: [SQL] Cumulative result with increment

On 02/07/2011 01:11 PM, Shawn Tayler wrote: Hello, I am struggling with what is probably a simple problem but I am coming up blank. In the interest of full disclosure I am not a very savy programmer by any stretch. I have a table of data from an external source which contains numbers of events

[SQL] why SELECT query needs relationname (schemaName.tableName)

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

Re: [SQL] why SELECT query needs relationname (schemaName.tableName)

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