"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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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