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

"char" quoted in column information schema view

From: "Rainer J(dot) H(dot) Brandt" <rjhb(at)bb-c(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: "char" quoted in column information schema view
Date: 2007-01-14 21:15:29
Message-ID: 17834.40305.208080.377920@gimli.bb-c.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi!

In the output below (seen with PostgreSQL 8.1.3 and 8.2.1),
is it intentional that "char" is quoted, or is it a bug?


Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

exp=> select distinct data_type from information_schema.columns;
        data_type         
--------------------------
 "char"
 ARRAY
 abstime
 anyarray
 bigint
 boolean
 bytea
 character
 character varying
 date
 inet
 integer
 name
 numeric
 oid
 real
 regproc
 smallint
 text
 time without time zone
 timestamp with time zone
 xid
(22 rows)




Greetings,
Rainer
-- 
----------------------------------------------------------------------
Rainer J. H. Brandt
Brandt & Brandt Computer GmbH
Email: rjhb(at)bb-c(dot)de
Mobile: +49 172 9593205

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-01-15 00:00:41
Subject: Re: "char" quoted in column information schema view
Previous:From: Ilya KoganDate: 2007-01-14 20:05:40
Subject: BUG #2893: Non-standard theme explodes the installer.

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