Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group