Skip site navigation (1) Skip section navigation (2)

Re: Viewing TEXT objects

From: Dave Page <dpage(at)pgadmin(dot)org>
To: mad rug <mad(dot)rug(dot)f(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Viewing TEXT objects
Date: 2009-09-30 19:52:53
Message-ID: 937d27e10909301252j6af192e0yb4fa09f245264b13@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
[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

In response to

Responses

pgadmin-support by date

Next:From: Michael ShapiroDate: 2009-09-30 20:28:59
Subject: Re: Viewing TEXT objects
Previous:From: Dave PageDate: 2009-09-30 19:42:04
Subject: Re: Viewing TEXT objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group