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.