Postgres Pro
Downloads
Home   >   mailing lists

Re: select from dynamic table names - Mailing list pgsql-general

From Pavel Stehule
Subject Re: select from dynamic table names
Date
Msg-id CAFj8pRCW6=Veziddff4ZGTZyPJnN7++upkSw9NRT5Th2=HUVYg@mail.gmail.com
Whole thread Raw
In response to select from dynamic table names  (Dinesh Kumara <dinesh@rezgateway.com>)
List pgsql-general
Tree view
Hello

2011/11/8 Dinesh Kumara <dinesh@rezgateway.com>
I have 16 tables which created according to generated MD5 hash.
At the time of execution i tried to retrieve data from a table where table name id dynamic.

table name can be expertdb.rate_AVAIL_[0 to F]

I tried to get this from ;
SELECT * FROM expertdb.rate_AVAIL_ || upper(substring(md5('2011-11-10')from 1 for 1))

but it is giving an error that is error with '||' appender. please someone give me an idea..

you can't do it on SQL level - column and table names must be constant

Regards

Pavel Stehule

 

--

Thanks and Regards,
Dinesh Kumara,
Software Engineer,
Reservation Gateway Inc,
Email:dinesh@rezgateway.com
www.rezgateway.com

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row
Next
From: "David Johnston"
Date:
Subject: Re: Returning a row from a function with an appended array field