Re: Viewing TEXT objects

What is wrong with these results? COL1 has the text value "88352"

On Wed, Sep 30, 2009 at 2:52 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> [Please keep the list CC'd]
>
> On Wed, Sep 30, 2009 at 8:49 PM, mad rug <mad(dot)rug(dot)f(at)gmail(dot)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?
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>