This blog post has moved. Please find it at:
http://www.mpopp.net/2005/12/mysql-postgresql/.
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
This is all about db4free.net and the database systems that it offers. The main focus are practical examples of the new features of MySQL 5 and 6 that should show you how to use them for your advantage in your daily life ;-).
About Me
Links
Blog Archive
-
▼
2005
(48)
-
▼
December
(16)
- New features in and not in MySQL 5.1
- MySQL - PostgreSQL reactions
- Breaking referential integrity
- MySQL - PostgreSQL
- The first week on my new job
- RTFM experiences
- db4free.net CleanUp process
- News about me & db4free.net
- Language specific MySQL.com website
- Simple or complex?
- TX isolation levels (4) How to produce an artifici...
- TX isolation levels (3) REPEATABLE READ, SERIALIZABLE
- Server statistics
- db4free.net data type statistics
- db4free.net offers MySQL 5.0 AND 5.1 databases
- db4free.net about to offer MySQL 5.1 databases as ...
-
▼
December
(16)
5 comments:
I am really interested in hearing more about the differences. It has been a couple months since you wrote this, do you have any updates?
Recently, I didn't do so much with PostgreSQL (more with Java, at the moment) - but when I return to PostgreSQL, there will certainly be more about this topic ;-).
PostgreSQL stores its user information inside the database as well.
select * from pg_user;
Will show you certain non-private user information if you have enough privilege, for instance. I don't know of any documentation listing all the system tables and what they are for, though.
Is it also possible to edit the user data in the pg_user table?
It wouldn't be that evil if it wouldn't be possible. However, I find it convenient that MySQL offers the option to directly edit privilege data.
As I know MySQL much better than PostgreSQL
After that I stopped reading.
You can't seriously be saying MySQL rocks, because it seriously doesn't.
Post a Comment