cast

From: Esteban Gutierrez Abarzua <esgutier(at)sauce(dot)chillan(dot)ubiobio(dot)cl>
To: pgsql-sql(at)postgresql(dot)org
Subject: cast
Date: 2001-10-22 22:35:22
Message-ID: Pine.LNX.4.21.0110221927020.5396-100000@sauce.chillan.ubiobio.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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!

Responses

  • Re: cast at 2001-10-23 02:17:08 from Stephan Szabo

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-10-23 02:17:08 Re: cast
Previous Message san 2001-10-22 21:25:44 PL/pgSQL triggers ON INSERT OR UPDATE