Re: Relation name stored in Postgres

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(dot)stehule(at)gmail(dot)com>
wrote:

>
>
> 2015-04-02 16:26 GMT+02:00 Ravi Kiran <ravi(dot)kolanpaka(at)gmail(dot)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(dot)stehule(at)gmail(dot)com>
>> wrote:
>>
>>> 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(dot)kolanpaka(at)gmail(dot)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
>>
>>
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.