Re: [GENERAL] Relation name stored in Postgres

2015-04-02 Thread Melvin Davidson
The table name is stored in pg_class when you execute the CREATE TABLE statement. The PostgreSQL main program, postmaster handles all the work. It appears to me your concept of how PostgreSQL works is very distorted. Perhaps you would best be served by purchasing and reading Beginning Databases

Re: [GENERAL] Relation name stored in Postgres

2015-04-02 Thread Pavel Stehule
2015-04-02 16:26 GMT+02:00 Ravi Kiran ravi.kolanp...@gmail.com: Hi, Thank you Sir. Also, could you tell me during which stage(whether parser,optimizer or executor) does the table name gets stored, and if possible could you tell me which program specifically does that. Usually parser,

[GENERAL] Relation name stored in Postgres

2015-04-02 Thread Ravi Kiran
Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name being stored. Thank you -- Regards, K.Ravikiran ᐧ

Re: [GENERAL] Relation name stored in Postgres

2015-04-02 Thread Pavel Stehule
Hi it is in system catalog - table pg_class, column relname Regards Pavel Stehule 2015-04-02 15:52 GMT+02:00 Ravi Kiran ravi.kolanp...@gmail.com: Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name being

Re: [GENERAL] Relation name stored in Postgres

2015-04-02 Thread Ravi Kiran
Hi, Thank you Sir. Also, could you tell me during which stage(whether parser,optimizer or executor) does the table name gets stored, and if possible could you tell me which program specifically does that. Thank you. ᐧ On Thu, Apr 2, 2015 at 7:32 PM, Pavel Stehule pavel.steh...@gmail.com wrote:

Re: [GENERAL] Relation name stored in Postgres

2015-04-02 Thread Ravi Kiran
Hi, Also, could you tell me during which stage(whether parser,optimizer or executor) does the table name gets stored, and if possible could you tell me which program specifically does that. ᐧ On Thu, Apr 2, 2015 at 7:56 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote: Hi, Thank you Sir.