Re: some error when executing query in pgAdmin tool

---

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] 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.