Skip site navigation (1) Skip section navigation (2)

Re: 'Range partitioning in PGSQL'

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Vibhor KumarDate: 2011-04-11 20:55:23
Subject: Re: Need SQL of create TABLE including INDEX and SEQUENCE
Previous:From: Michael GlaesemannDate: 2011-04-11 20:30:52
Subject: Re: 'Range partitioning in PGSQL'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group