This is a live blog (i.e. I’d be updating this post time by time.
I am starting to use PostgreSQL as Object Database, mainly as a part of my course project. Object oriented extension of SQL is quite interesting – I, kinda, am loving it. However, all object oriented extensions are not yet implemented by vendors. PostgreSQL lacks a lot of them. Here, in this post, I am going to put notes about what I encounter.
I am using PostgreSQL v9.3.0.
No type inheritance
I tried to use the cool feature of SQL with the keyword
under, which was supposed work like
extend keyword for type inheritance. e.g.:
CREATE TYPE StudentType UNDER PersonType AS ( Id INTEGER, Level CHAR(2) )
However, table inheritance is still available, e.g.:
CREATE TABLE Students( Id INTEGER, Level CHAR(2) ) INHERITS (Persons);
List all tables
select * from information_schema.tables