Thread: Relation name stored in Postgres
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
Hi
it is in system catalog - table pg_class, column relname2015-04-02 15:52 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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 stored.Thank you--Regards,K.Ravikiran
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.stehule@gmail.com> wrote:
Pavel StehuleRegardsHiit is in system catalog - table pg_class, column relname2015-04-02 15:52 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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 stored.Thank you--Regards,K.Ravikiran
Regards,
K.Ravikiran
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.kolanpaka@gmail.com> wrote:
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.stehule@gmail.com> wrote:Pavel StehuleRegardsHiit is in system catalog - table pg_class, column relname2015-04-02 15:52 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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 stored.Thank you--Regards,K.RavikiranRegards,K.Ravikiran
Regards,
K.Ravikiran
2015-04-02 16:26 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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, optimizer and command execution work with data from pg_class table. I don't understand to second question. if you need some points to postgresql source code - then magic word is "relname"
Regards
Pavel
Thank you.ᐧ
--On Thu, Apr 2, 2015 at 7:32 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Pavel StehuleRegardsHiit is in system catalog - table pg_class, column relname2015-04-02 15:52 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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 stored.Thank you--Regards,K.RavikiranRegards,K.Ravikiran
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 With PostgreSQL".http://www.amazon.com/Beginning-Databases-PostgreSQL-Novice-Professional/dp/1590594789/ref=sr_1_2?s=books&ie=UTF8&qid=1427987843&sr=1-2&keywords=postgresql
On Thu, Apr 2, 2015 at 10:43 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
2015-04-02 16:26 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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, optimizer and command execution work with data from pg_class table. I don't understand to second question. if you need some points to postgresql source code - then magic word is "relname"RegardsPavelThank you.--On Thu, Apr 2, 2015 at 7:32 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Pavel StehuleRegardsHiit is in system catalog - table pg_class, column relname2015-04-02 15:52 GMT+02:00 Ravi Kiran <ravi.kolanpaka@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 stored.Thank you--Regards,K.RavikiranRegards,K.Ravikiran
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.