Table PARTITION - Mailing list pgsql-sql

From Dinesh Pandey
Subject Table PARTITION
Date
Msg-id 20050407114136.17B7E53AA5@svr1.postgresql.org
Whole thread Raw
Responses Re: Table PARTITION  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
<p><font face="Verdana" size="2">How can we create oracle's table with partition in Postgres. (How to create Table
partionin postgres)</font><p><font face="Verdana" size="2">CREATE TABLE invoices</font><br /><font face="Verdana"
size="2">(invoice_no   NUMBER NOT NULL, </font><br /><font face="Verdana" size="2"> invoice_date  DATE   NOT
NULL,</font><br/><font face="Verdana" size="2"> comments      VARCHAR2(500))</font><p><b><font face="Verdana"
size="2">PARTITIONBY RANGE</font></b> <font face="Verdana" size="2">(invoice_date)</font><br /><font face="Verdana"
size="2">(PARTITIONinvoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001', 'DD/MM/YYYY')) TABLESPACE users</font><p><font
face="Verdana"size="2">Regards<br /> Dinesh Pandey</font><font face="Times New Roman"><br /><br /><br /></font><b><font
color="#808080"face="Times New Roman"
size="2">----------------------------------------------------------------------------------</font></b><br
/><b></b><b><fontcolor="#808080" face="Verdana" size="2">Dinesh Pandey</font></b><font face="Verdana"
size="2"> </font><fontcolor="#808080" face="Verdana" size="2"></font><br /><font color="#808080" face="Verdana"
size="2">Sr.Software Engineer<br /><br /> Second Foundation (India) Pvt. Ltd.<br /> Plot# 52<br /> Industrial Area,
PhaseII<br /> Chandigarh. (India)<br /> PH: (O) 0172-2639202, Extn: 233</font> 

pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: Re: [despammed] Crosstab function
Next
From: Richard Huxton
Date:
Subject: Re: Table PARTITION