Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-07-01 Thread Jason McManus
Hi Dave, Documentation such as this can be added to the new techdocs area on the main site at http://www.postgresql.org/docs/techdocs under the relevant section (probably http://www.postgresql.org/docs/techdocs.3 in this case). Please note that the editting interface is still new and may still

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Jason McManus
I don't believe there is any fixed "default character set". Each installation will have a default locale and encoding, but these depend on the locale under which initdb was run. From the above comment I surmise that you initdb'd under some UTF8-using locale ... Ah, great. Thank you for the cl

[GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Jason McManus
the best of the 3 that I had access to. YMMV. More info in the book reviews linked below. Further information: PostgreSQL manual: http://www.postgresql.org/docs/manuals/ PgAdmin3: http://www.pgadmin.org/ PostgreSQL book reviews: http://techdocs.postgresql.org/techdocs/bookreviews.ph