pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate Table and Index Definition for Partitions
2+ messages / 2 participants
[nested] [flat]
* Create Table and Index Definition for Partitions
@ 2004-08-05 23:33 Jerry Champlin <jchamplin@absolute-performance.com>
2004-08-14 09:30 ` Re: Create Table and Index Definition for Partitions Simon@2ndquadrant.com <simon@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jerry Champlin @ 2004-08-05 23:33 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Create Table and Index Definition for Partitions
2004-08-05 23:33 Create Table and Index Definition for Partitions Jerry Champlin <jchamplin@absolute-performance.com>
@ 2004-08-14 09:30 ` Simon@2ndquadrant.com <simon@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Simon@2ndquadrant.com @ 2004-08-14 09:30 UTC (permalink / raw)
To: jchamplin@absolute-performance.com; pgsql-docs
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-14 09:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-05 23:33 Create Table and Index Definition for Partitions Jerry Champlin <jchamplin@absolute-performance.com>
2004-08-14 09:30 ` Simon@2ndquadrant.com <simon@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox