| 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: | Whole Thread | Raw Message | 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!
| 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 |