Postgres is a super excellent RDBMS and object database which integreted with various number of functionalities exceed current average level of other database productions.
Rugal also become a member of developer in pg-hacker. Here I want to introduce some basic usage in Postgres command line prompt:
When thinking about postgres’s data organization, I made a conclusion below:
datafile -> tablespace -> database ->schema -> table
But I did not get detailed knowledge like
segment/extent in Oracle.
I think Postgres is awesome, high performance and well organized. Good resource to study and backended as DBMS.