[SQL] cast

[Esteban Gutierrez Abarzua]

hi.

I wanna to make a query on this table(postgres system catalog):

 Attribute   |   Type    | Modifier 
--------------+-----------+----------
 relname      | name      | 
 reltype      | oid       | 
 relowner     | integer   | 
 relam        | oid       | 
 relpages     | integer   | 
 reltuples    | integer   | 
 .....
 .....
 ... 
.
  select relname from pg_class;

  How can I get a char or varchar cast for the name data type?....
  because relname is a name data type and I want to get a char or varchar
data type.  


  bye .


 my english is no so good!


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])