Actually I need to know 'how' a table and its attributes get stored in the database whenever i write 'create table' query. I have understood parsing phase but i want to know after parsing which files are accessed exactly for creating & storing the table?
In regardsa to metadata, take a look at the "Information Schema" in the documentation.
As far as the table creation... When a table is created, it is assigned a table OID (Object ID) number, which is a 32 bit integer, and which can be found in the metadata. That integer is then used in creating the file which contains the table data. The location of the file is determined by the tablespace which it is assigned. The tablespace is, of course, a named folder path.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert