Re: Viewing TEXT objects

[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