Thread: "char" quoted in column information schema view

"char" quoted in column information schema view

From
"Rainer J. H. Brandt"
Date:
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@bb-c.de
Mobile: +49 172 9593205

Re: "char" quoted in column information schema view

From
Tom Lane
Date:
"Rainer J. H. Brandt" <rjhb@bb-c.de> writes:
> 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?

It's intentional --- that type is not the same as CHAR(n).

            regards, tom lane