Re: [SQL] some error when executing query in pgAdmin tool

[Dave Page]

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P. Sent: 23 May 2006 13:11 To: pgsql-sql@postgresql.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.