Re: Relation name stored in Postgres - Mailing list pgsql-general
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.
pgsql-general by date: