Re: [DOCS] Create Table and Index Definition for Partitions
> 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 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[DOCS] sql.sgml
Looking through the documentation source, I came across sql.sgml, a section that covers relational theory and SQL. It's no longer compiled with the docs, afaics, and hasn't been since 7.1. We often get questions regarding this kind of basic information in #postgresql on irc.freenode.net, and people have commented that such a reference would be useful. I'd like to be able to point people to such a reference in the docs (we currently point then to books or other websites). Perhaps we should include it in the documentation again? Probably needs a little polishing, but that can be done. Thoughts? Michael Glaesemann grzm myrealbox com ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [DOCS] sql.sgml
Michael Glaesemann <[EMAIL PROTECTED]> writes: > Looking through the documentation source, I came across sql.sgml, a > section that covers relational theory and SQL. It's no longer compiled > with the docs, afaics, and hasn't been since 7.1. I am not totally sure why we stopped including that, but I seem to recall that we couldn't get all the mathematical notation to convert to DocBook nicely. I also misdoubt that the math wouldn't scare off the people who need it most. I agree that a little bit of basic theory might go well as a chapter in the tutorial ... but whether this is a good starting point is another question. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
