Table PARTITION
| От | Dinesh Pandey |
|---|---|
| Тема | Table PARTITION |
| Дата | |
| Msg-id | 20050407114136.17B7E53AA5@svr1.postgresql.org обсуждение исходный текст |
| Ответы |
Re: Table PARTITION
|
| Список | 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 по дате отправления: