Re: column doesnt exist?

On Thu, 18 Nov 2004, Cao Duy wrote:

> hi,
>
> I created this table:
> CREATE TABLE public.stresslog(
> "AbfrageId" int8 NOT NULL DEFAULT
> nextval('public."stresslog_AbfrageId_seq"'::text),
> "AbfrageTyp" varchar(50) NOT NULL,
> "Abfrage" varchar(300),
> "AnzZeilen" int8 DEFAULT 0,
> "ZeitVerbrauch" int8 DEFAULT 0,
> "AnzCon" int4 DEFAULT 0,
> "AnzSchreib" int4 DEFAULT 0,
> "AnzLesen" int4 DEFAULT 0,
> "AnzTabDs" int8 DEFAULT 0,
> "TabName" varchar(100),
> "AnzAnweisungen" int4 DEFAULT 1,
> "SystemMeldung" varchar(100) DEFAULT 'OK'::character varying,
> "AusfuehrungsZeit" date,
> CONSTRAINT stresslog_pkey PRIMARY KEY ("AbfrageId")
> ) WITHOUT OIDS;
>
> I try to execute the following statement and get this err.msg:
> select AbfrageTyp from stresslog

Unquoted column names are casefolded (in PostgreSQL to lowercase, in
standard SQL to uppercase). You need to say select "AbfrageTyp" from
stresslog if you create the table with double quoted column names.