public inbox for [email protected]  

help / color / mirror / Atom feed

Create 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 <[email protected]>
  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-14 09:30  [email protected] <[email protected]>
  parent: Jerry Champlin <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: [email protected] @ 2004-08-14 09:30 UTC (permalink / raw)
  To: [email protected]; 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 <[email protected]>
2004-08-14 09:30 ` [email protected] <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox