From jchamplin@absolute-performance.com Sat Jun 6 10:20:23 2026 X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 49D11D1B1D5 for ; Thu, 5 Aug 2004 20:34:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41331-06 for ; Thu, 5 Aug 2004 23:34:07 +0000 (GMT) Received: from absolute-performance.com (mx01.den.sysshep.com [216.87.69.82]) by svr1.postgresql.org (Postfix) with ESMTP id DF6EAD1B1D1 for ; Thu, 5 Aug 2004 20:34:02 -0300 (ADT) Received: from bigring (boulder.absolute-performance.com [69.15.81.122] (may be forged)) (authenticated bits=0) by absolute-performance.com (8.12.8/8.12.8) with ESMTP id i75NXugH017920 for ; Thu, 5 Aug 2004 23:34:05 GMT Reply-To: From: "Jerry Champlin" To: Subject: Create Table and Index Definition for Partitions Date: Thu, 5 Aug 2004 17:33:40 -0600 Organization: Absolute Performance, Inc. Message-ID: <002e01c47b44$a6d954f0$9901a8c0@bigring> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002F_01C47B12.5C3EE4F0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/6 X-Sequence-Number: 2466 This is a multi-part message in MIME format. ------=_NextPart_000_002F_01C47B12.5C3EE4F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I'm currently putting together a tool to migrate schema definitions from Oracle to PostgreSQL. It's written in perl and easily extensible by others to add functionality I don't care to migrate. I need to know how to properly format create table, alter table, create index and alter index commands for the partitioning functionality about to be released. Could someone please provide a draft of that documentation or point me to the appropriate place in the code tree to figure it out. Thanks Jerry Champlin Absolute Performance ------=_NextPart_000_002F_01C47B12.5C3EE4F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
I'm curre= ntly=20 putting together a tool to migrate schema definitions from Oracle to=20 PostgreSQL.  It's written in perl and easily extensible by others to a= dd=20 functionality I don't care to migrate.  I need to know how to properly= =20 format create table, alter table, create index and alter index commands for= the=20 partitioning functionality about to be released.  Could someone please= =20 provide a draft of that documentation or point me to the appropriate place = in=20 the code tree to figure it out.
 
Thanks
 
Jerry Champlin
Absolute=20 Performance
------=_NextPart_000_002F_01C47B12.5C3EE4F0-- From simon@2ndquadrant.com Sat Jun 6 10:20:23 2026 X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0D4605E46D2 for ; Sat, 14 Aug 2004 06:16:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39840-04 for ; Sat, 14 Aug 2004 09:16:06 +0000 (GMT) Received: from cmailm4.svr.pol.co.uk (cmailm4.svr.pol.co.uk [195.92.193.211]) by svr1.postgresql.org (Postfix) with ESMTP id AAB2C5E46CF for ; Sat, 14 Aug 2004 06:16:04 -0300 (ADT) Received: from modem-2834.leopard.dialup.pol.co.uk ([217.135.155.18] helo=happyplace) by cmailm4.svr.pol.co.uk with smtp (Exim 4.14) id 1Bvudt-00084C-Bo; Sat, 14 Aug 2004 10:16:01 +0100 From: "Simon@2ndquadrant.com" To: , Subject: Re: Create Table and Index Definition for Partitions Date: Sat, 14 Aug 2004 10:30:13 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal In-Reply-To: <002e01c47b44$a6d954f0$9901a8c0@bigring> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/34 X-Sequence-Number: 2494 > Jerry Champlin wrote I'm currently putting together a tool to migrate schema definitions from Oracle to PostgreSQL. It's written in perl and easily extensible by others to add functionality I don't care to migrate. I need to know how to properly format create table, alter table, create index and alter index commands for the partitioning functionality about to be released. Could someone please provide a draft of that documentation or point me to the appropriate place in the code tree to figure it out. First off, there's already a tool to do this... ora2pg The functionality just released is for Tablespaces, not Partitions, which is a different concept altogether. The docs are available on-line for the SQL DDL statements you mention. Look at the docs via http://developer.postgresql.org/docs/postgres/index.html Best Regards, Simon Riggs