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

SQL problem?

From: cbraden <cbraden(at)douglasknight(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL problem?
Date: 2005-08-24 16:22:23
Message-ID: 430C9EBF.5010905@douglasknight.com (view raw or flat)
Thread:
Lists: pgsql-novice
Folks,

I have a simple table called "adjusters" with only these three columns:

id
adjuster
MonthlyGoal

==========COPIED FROM PGAdminIII=============
CREATE TABLE public.adjusters
(
id int4 NOT NULL DEFAULT nextval('adjusters_id_key'::text),
"Adjuster" varchar(50),
"MonthlyGoal" varchar(50),
CONSTRAINT adjusters_pkey PRIMARY KEY (id)
) WITH OIDS;
==============================================

The SQL "SELECT * FROM adjusters" works perfectly

The SQL "SELECT * FROM adjusters ORDER BY Adjuster ASC" results in this 
message:
ERROR: Attribute "adjuster" not found


That SQL seems OK to me, but I use mySQL much more than Postgre, so what 
do I know?

Anyway, if you see whatever-it-is which is holding me up, please let me 
know.

Thanks,
Char-Lez Braden

In response to

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2005-08-24 16:32:39
Subject: Re: Transaction Questions
Previous:From: Tom LaneDate: 2005-08-24 15:13:59
Subject: Re: function to escape single quotes

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