view?

Hi,

Currently psql show views like:

Database = hygea
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| postgres | abbattimenti | table |
| postgres | wattivita | view? |
| postgres | attivita_a | table |

because it seeks for relhasrules field and if you have a table (not a
table) with a rule it thinks it is a view
and displays "view?" instead of "table".

I modified psql.c to use pg_get_viewdef() function to seek for views and
now I can display only tables using \dt
or only views using \dv like:hygea=> \dv

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

\dt
Database = hygea
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| postgres | abbattimenti | table |
| postgres | attivita | table |
| postgres | attivita_a | table |
| postgres | attivita_b | table |
| postgres | brogliacci | table |
| postgres | capi | table |
| postgres | comuni | table |
+------------------+----------------------------------+----------+

If this interests to someone there is the attached patch.

-Jose'-