Re: some error when executing query in pgAdmin tool

________________________________

From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Penchalaiah P.
Sent: 23 May 2006 13:11
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] some error when executing query in pgAdmin tool

I created one table in pgAdmin tool but when I am executing
query it is giving error....

CREATE TABLE "ADV"

(

"T-Section_Id" varchar(10) NOT NULL,

"CDA_No" varchar(7) NOT NULL,

"Imp_Schedule_Id" int4 NOT NULL,

"Sanction_No" varchar(20) NOT NULL,

"Sanction_Date" date NOT NULL,

"Station_From" varchar(20) NOT NULL,

"Station_To" varchar(20) NOT NULL,

"Amt_Claimed" int4,

"Amt_Admitted" int4,

"Dak_Id" varchar(20) NOT NULL,

"Refund_Dak_Id" int4 NOT NULL,

"T-Wing_Allowance_Id" varchar(10) NOT NULL,

CONSTRAINT "ADV_pkey" PRIMARY KEY ("T-Section_Id")

)

WITHOUT OIDS;

ALTER TABLE "ADV" OWNER TO postgres;

Above table I created.....

Select * from ADV; when I am executing this query I am getting
error is

Relation ADV does not exist... like this error is giving ... may
I know y am I getting this error

Try

SELECT * FROM "ADV";

pgAdmin quoted the tablename because you used uppercase characters.
Without the quotes, the name is folded to lowercase.

Regards, Dave.