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

Character type name?? How to lower case it?

From: Douglas Nichols <dnichols(at)fhcrc(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Character type name?? How to lower case it?
Date: 1999-01-28 20:56:21
Message-ID: 36B0CEF5.A49B6E32@fhcrc.org (view raw or flat)
Thread:
Lists: pgsql-sql
I have this script:
      SELECT a.attname, t.typname, a.attlen
        FROM pg_class c, pg_attribute a, pg_type t
          WHERE c.relname = 'regis' and a.attname in
('var1','var2',var3');

but a.attname is of type name, inwhich text(..) or lower(..)
do not work with this type and I do not seem to be able to
convert type name to text....

Can someone help me get around this?

Thanks 
-- 
Cheers

Douglas Nichols                                          
dnichols(at)fhcrc(dot)org
----------------------------------------------------------------------------
Fred Hutchinson Cancer Research Center

Responses

pgsql-sql by date

Next:From: Bryan WhiteDate: 1999-01-28 21:48:20
Subject: Re: [SQL] Auto-Vacuum?
Previous:From: Tim PerdueDate: 1999-01-28 19:10:23
Subject: Re: [SQL] Auto-Vacuum?

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