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