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.
> • 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.
Thanks & Regards,
The Enterprise PostgreSQL Company
In response to
pgsql-novice by date
|Next:||From: Vibhor Kumar||Date: 2011-04-11 20:55:23|
|Subject: Re: Need SQL of create TABLE including INDEX and SEQUENCE|
|Previous:||From: Michael Glaesemann||Date: 2011-04-11 20:30:52|
|Subject: Re: 'Range partitioning in PGSQL' |