Re: [HACKERS] view?

Constantin Teodorescu ha scritto:

> Jan Wieck wrote:
> >
> > Jose' Soares wrote:
> >
> > > I modified psql.c to use pg_get_viewdef() function to seek for views and
> > > now I can display only tables using \dt
> >
> >  I suggest not to apply this patch
> >
> >  1.  The  function  pg_get_viewdef()  is  definitely  too much
> >      overhead. In fact it must parse back  the  complete  view
> >      .......
>
> I used pg_get_viewdef() function to properly detect views and tables in
> PgAccess.
> For the moment, I have released a new version 0.94 of PgAccess based on
> this and it works fine.
>
> I am sure that you are right concerning pg_get_viewdef() function, but
> please, could you tell me another way of detecting views from "false
> views" ? relhasrules field isn't good enough for it and for the moment,
> pg_get_viewdef() seems to be a good method. If anyone could tell me
> another way of safely detecting views I can change it.
>
> Also, I used pg_get_viewdef() in order to get views's definition for the
> "Design" view function so, I will need also such a function in order to
> implement this feature.
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA

I'm not sure if we may consider  good the pg_views data.
If so you can check for views into it, as..

hygea=> \d pg_views

Table    = pg_views
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| viewname                         | name                             |    32 |
| viewowner                        | name                             |    32 |
| definition                       | text                             |   var |
+----------------------------------+----------------------------------+-------+

hygea=> \dv
Database    = hygea+------------------+----------------------------------+----------+|  Owner           |
Relation            |   Type   |+------------------+----------------------------------+----------+| postgres         |
wattivita                       | view     || postgres         | wtabelle                         | view
|+------------------+----------------------------------+----------+

hygea=> select 'yes' from pg_views where viewname='wattivita';
?column?
--------
yes
(1 row)

-Jose'-