| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Saseendra Babu <saseendra(at)cdactvm(dot)in> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: 'Range partitioning in PGSQL' |
| Date: | 2011-04-11 20:42:37 |
| Message-ID: | 18BC14BC-BD53-47CD-A33F-62468B2FFCE2@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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 corresponding partitions.
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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vibhor Kumar | 2011-04-11 20:55:23 | Re: Need SQL of create TABLE including INDEX and SEQUENCE |
| Previous Message | Michael Glaesemann | 2011-04-11 20:30:52 | Re: 'Range partitioning in PGSQL' |