Thread: cast

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
achar or varchar
 
data type.  

 bye .

my english is no so good!

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.