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

    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.

  2. #2
    Join Date
    Sep 2011
    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
    Arizona, USA
    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

Posting Permissions

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