I'm far from a PostgreSQL expert myself, but the way I taught myself was by using their GUI, pgAdmin III, and just poking around. Postgres has a lot more features than MySQL including a much richer set of datatypes (though be careful with this: I got a little bit too excited when I discovered arrays and made my schema less relational than it should have been). It supports table inheritance which I found convenient. But at it's core, it's a relational database and the kind of relational schema you are used to from MySQL should work the same here.
-Alessandro
On Tue, Jul 24, 2012 at 2:30 PM,
<fpiraneo@gmail.com> wrote:
Hi all,
after eight years of using MySQL I learned about pgsql and I'm evaluating if it's the case to use it on a new coming project where reliability is a must.
I've seen that pgsql is a DBMS that is "object oriented", that's mean that the data can be organized not only as tables with data to join on relations but also on object that can simplify the management of "real world data": WOW!
I searched on Amazon for books explaining how to unleash the full power of an "object oriented data base" but I've found books explaining the basic of SQL (how to select, how to insert, joins between tables) that are concepts that I already know; I think that a revolutionary product like pgsql is, needs a different approach on design and query; now the question:
Can you suggest books and / or websites where this different approach (if needed) can be learn? Is my idea about this "different approach" totally wrong and pgsql is not so different than other DBMS?
Thanks a lot.
Francesco
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice