Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    9

    Unanswered: Metadata of PostgreSql

    Hello all,
    I am working on PostgreSql query optimization, so i want to know how to handle metadata of PostgreSql. Can anyone pls tell me how to do it?
    Plz reply asap.
    Regards,
    Aditi.

  2. #2
    Join Date
    Sep 2011
    Posts
    9
    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?

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    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.
    Lou
    使大吃一惊
    "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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •