SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 10:31 AM
| ||||
| ||||
 "char" quoted in column information schema view 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings      |
|
04-10-2008, 10:31 AM
| ||||
| ||||
| Re: "char" quoted in column information schema view "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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
Linear Mode
