From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: some error when executing query in pgAdmin tool |
Date: | 2006-05-23 12:06:12 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E401388437@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
________________________________
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-05-23 12:10:38 | Re: some error when executing query in pgAdmin tool |
Previous Message | Achilleus Mantzios | 2006-05-23 05:39:10 | Re: Does PG have a database |