Re: 'Range partitioning in PGSQL'

On Apr 11, 2011, at 1:34 PM, Saseendra Babu wrote:

> What we require is as follows.
>     • In the insert statement we shall specify only the table name ( not the partition name)
>     • The rows are be populated in to the corresponding partions

Yes it is possible in PostgreSQL.
http://www.postgresql.org/docs/9.0/interactive/ddl-partitioning.html


>     •  In select also we should only the table name ( not the partition name). rows are to be retrieved  from
correspondingpartitions. 

This is possible. constraint_exclusion=partition/on

>     • While using partition  by inheritance,  we have to specify the partition,  ie  child  table name.
Not require.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com