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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
