Re: cast

On Mon, 22 Oct 2001, Esteban Gutierrez Abarzua wrote:

> 
> 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.  

In general, I think name and varchar(<identifier length>) are pretty
equivalent, but...

select CAST(relname as varchar) AS relname from pg_class;
should work.