What is wrong with these results? COL1 has the text value "88352"
On Wed, Sep 30, 2009 at 2:52 PM, Dave Page <dpage@pgadmin.org> wrote:
[Please keep the list CC'd]
On Wed, Sep 30, 2009 at 8:49 PM, mad rug <mad.rug.f@gmail.com> wrote: > Hi >
> This is the definition: > > CREATE TABLE "TBL" > ( > "ID" bigint NOT NULL, > "COL1" text NOT NULL, > "COL2" integer NOT NULL, > "COL3" character(2) NOT NULL, > CONSTRAINT "TBL_pkey" PRIMARY KEY ("ID") > ) > WITH (OIDS=FALSE); > ALTER TABLE "TBL" OWNER TO postgres; > > This is what I get with a select * from "TBL" (csv export): > "ID";"COL1";"COL2";"COL3" > 1;"88352";53125;"RE" > > The data is correct somewhere... I can query it correctly through JDBC.
Hmm, no reason that shouldn't work. Are you sure you're connecting to the same database in pgAdmin vs. JDBC? Or that you don't have another table of the same name in a different schema?