Re: Distinguish view and table problem

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
Cc: suzhiyang <suzhiyang(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Distinguish view and table problem
Date: 2009-12-19 15:19:34
Message-ID: 3073cc9b0912190719vdab9a2cu26f8febfe96b6121@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2009/12/19 Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>:
>
> W dniu 19 grudnia 2009 03:20 użytkownik suzhiyang <suzhiyang(at)gmail(dot)com>
> napisał:
>>
>> Sorry, I've not describe my problem precisely.
>> I mean that  I want to get relkind or something from a systable by the
>> programm but not by sql.
>
> I don't understand how you can get data from table without using SQL. (maybe
> I'm just "too sql")
>

i think he is hacking postgres's source code to make the TODO: "allow
recompilation of views" (he send an email about that in another
thread)...

i think this is somewhat necesary to read:
http://wiki.postgresql.org/wiki/Developer_FAQ#Technical_Questions
and of course look at other files that acces that kind of info, for
example look at AlterTableNamespace() funtion in
src/backend/commands/tablecmds.c to find out for a complete example to
identify tables and views

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-12-19 15:32:42 Re: COPY IN as SELECT target
Previous Message Jaime Casanova 2009-12-19 14:43:16 Re: Re: [COMMITTERS] pgsql: Allow read only connections during recovery, known as Hot